[AccessD] Sel Start and Sel Length not working for me

Rocky Smolin rockysmolin at bchacc.com
Thu Apr 2 16:12:14 CDT 2009


Rats.  Still nothing.  I've done this before in other apps, too. And had it
work.  

Rocky
 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Charlotte Foust
Sent: Thursday, April 02, 2009 1:50 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Sel Start and Sel Length not working for me

That was a bit of very old code, probably from 2k.  Switch the control out
for a textbox and see how that works.  Basically, what you're telling it to
do is start at the zero position and set the SelLength to the length of the
control.text in the control.

Charlotte Foust

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin
Sent: Thursday, April 02, 2009 1:03 PM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] Sel Start and Sel Length not working for me

 Charlotte:

I pasted in the SelectEntire module and called it with Call
SelectEntire(Me.fldFHxDetaiMotherResponse) but no cigar.  

Rocky


-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Charlotte Foust
Sent: Thursday, April 02, 2009 12:37 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Sel Start and Sel Length not working for me

Public Sub SelectEntire(ctl As Control)
  On Error Resume Next
  ctl.SelStart = 0
  ctl.SelLength = Len(ctl.Text) + 1
  If Err <> 0 Then
    ctl.SelLength = Len(ctl.Value) + 1
  End If
End Sub


Charlotte Foust 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin
Sent: Thursday, April 02, 2009 12:03 PM
To: 'Access Developers discussion and problem solving'
Subject: [AccessD] Sel Start and Sel Length not working for me

Dear List:

In the got focus event of a bound text box I want to have all the current
text selected.  The box can only have a 0 or 1.It is bound to a field of
data type number

The following code should (I think, but obviously not) select all the text
in the box but doesn't.  Can anyone see why?

 

    Me.fldFHxDetailMotherResponse.SelStart = 0
    Me.fldFHxDetailMotherResponse.SelLength =
len(Me.fldFHxDetailMotherResponse)

I also tried:

    Me.fldFHxDetailMotherResponse.SelStart = 0
    Me.fldFHxDetailMotherResponse.SelLength = 1


just to make things simple.  But no soap.

 
MTIA,
 

Rocky Smolin

Beach Access Software

858-259-4334

www.e-z-mrp.com <http://www.e-z-mrp.com/> 

www.bchacc.com <http://www.bchacc.com/> 

 

 





--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com




More information about the AccessD mailing list