Known issue with copying Controls from 03 to 2007

[Chris f via AccessMonster.com]

Hello-

This is a continuation of a question asked earlier in regards to highlighting
inputted data in a text box on the After_Update. Based upon the response to
the earlier post I encountered the same problem, when running the code .
SelLength = Len(Me.TextBox.Text) or .SelLength = Len(Me.TextBox.Value), the
cursor remains before the first character entered in the text box.

To try and recreate the problem, I created a new Access 2007 database and on
a form created a text box with the code in the After_Update to highlight the
text, and instead of creating the same error, actually highlighted the text.

I then went into the form that I was having the trouble with highlighted text
box, created a new text box and the same code, and again the same problem.

I further explored this by in the existing database, created a new form with
a text box and the after_Update event, and it highlighted the text.

I then copied all the controls out of the one form I was having a problem
with, and created a new form and tried it again, and again I get the same
problem where it does not highlight and places the cursor before the actual
text.

Analysising the existing form I am having a problem with, I copied these
controls from form from a 03 mdb file. That is the only difference. Has any
problems like this been experienced with 07 or does anyone know of a fix,
besides redoing the form using 07 controls?

Thanks,
CF

 

[Albert D. Kallal]

I further explored this by in the existing database, created a new form
with
a text box and the after_Update event, and it highlighted the text.

the above is surprising...sure you not talking about the new database?

Analysising the existing form I am having a problem with, I copied these
controls from form from a 03 mdb file. That is the only difference. Has
any
problems like this been experienced with 07 or does anyone know of a fix,
besides redoing the form using 07 controls?

I experienced this problem, but it was due to the "default" setting in which
the field gets highlighted.

in a2003, check:

tools->options->keyboard
The option that works for me is
Behavior entering field---> Select entire field

In a2007, check:

office button->Access options->advanced, the 2nd entry is Behavior
entering field.

Check the above settings, that could be your problem...

 

[Chris F via AccessMonster.com]

Hi Albert-

What I did was take controls from an 03 database and created a new database
in 07 and pasted the controls in a form.

However I do not think that is the problem. As mentioned previously, I
created a new form in 07 and added one text box. The .selLenght code in the
after_update event worked properly in where it highlighted what ever data I
placed in textbox 1. But when I added a second text box to the same form,
and tried running the after_update event on textbox 1, it automatically put
the cursor in textbox 2, rather than highlight the data entered in textbox 1
and creating the unexpected results as experienced on the existing form.

Am I missing something here?
Thanks,
Chris F