Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Eliminating a Beginning Space

Status
Not open for further replies.

cpsqlrwn

IS-IT--Management
Jul 13, 2006
106
US
I have a combo box control with limit to list set to yes in a form with msgbox validation code to prevent a blank field where the code works fine unless a space is entered in the control. Then my validation code is preempted by end/debug messages. Is there a way to refer to this type of instance (a field beginning with a space) with code so that it can be included in the validation criteria?
 
Perhaps the LTrim function ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top