Highlighting on Forms

[ASherbuck]

Hello,

Here is my situation, currently I have a text box bound to a field where users can scan a barcode and bring up the information if the barcode finds a match.

My problem is, if the barcode is not in the database then after users hit ok to the not found message box it leaves the number in the box and puts the cursor at the end.

This is a small issue but would save a lot of time, what would I need to change to get the field to highlight after a number is entered, regardless of whether the item is found?

It would save employees time having to highlight each item, this could get tedious after the first 1000 scans.

 

[ajetrumpet]

Highlight? Are you talking about Setting focus to the control, or actually filling the box's background with an actual color?

 

[GolferGuy]

Try "SelLength"
It is available to use to set the len of what is selected within the text box that has the control. Look it up in Access VBA Help. I'd explain how to use it except I have not been able to get it to work the way I have wanted, but you might have more luck. Please let us know what you find out.