Leading spaces

[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.

 

[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

 

[Chris Emery]

Thanks Arvin, works perfectly.

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

Sub txtControlName_AfterUpdate()
Me.txtControlName = LTrim(Me.txtControlName)
End Sub
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com