Hi, is there a way we can disable the spacebar for one field. See we are scanning the tracking codes in that field but if by mistake a spacear is pressed and then the code is scanned. The person who is searching (via combo box) can not track it since there is one empty space from the start.

Thanks for the help in advance

Rajput

In the AfterUpdate event of the control, use the Trim() function to eliminate leading/trailing spaces. Make sure that the control name and the bound column name are different or you will get a compile error since Access won't be able to tell if you are referencing the control or the field from the recordsource.

I am sorry I am new at this, Pl. explain further.

Rajput