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

Also,
The reason for this is that your code is working when you tab into it but
when you click on it - well, it is doing what you are telling it to do which
is "select the current entry at the point when I click". It cannot be any
thing other than that Rocky.  You wouldn't want to click on a field and then
have it position at the first character when you click on the, say 20th
character with the aim of changing  it from A to B.  If it done that then
the only way left would the to right arrow along to the character you want,
each and every time you clicked on a field.  Think about it!


Max



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

Ah, good one!  When I tab into it I get the field selected.  Click, no go. 

If I put the call into the click event, then walla!, data selected.  

Unfortunately I have 14 of these little text boxes on the form so I'll have
to have both a click and an enter event calling the text selector for each
one.

Problem solved.  

Thanks once again to all for your help. 

Best,

Rocky


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

I bet if you TAB into it, it selects the current value. Allowing you to
overtype.
If you click on it, then it probably won't

Max



-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin
Sent: 02 April 2009 20:03
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