Leading spaces

C

Chris Emery

What is a good way to prevent leading spaces being entered in a name? I
know I can do a LTrim update query afterwards but I thought there might be
an easier way at the data entry form stage.

Chris in Canberra, Australia.
 
A

Arvin Meyer [MVP]

Sure, do an LTrim in the control's AfterUdate event. Something like:

Sub txtControlName_AfterUpdate()
Me.txtControlName = LTrim(Me.txtControlName)
End Sub
 
Top