Correct population of a textbox

[Peter]

Hi again.....i am almost ready with by database..just fixing small issue
here and there...

How do i ensure that a textbox gets correctly populated...
i.e i have noticed that it is possible to enter the data with two or three
empty spaces in the beginning of the textbox..

Thanks again!

 

[fredg]

Hi again.....i am almost ready with by database..just fixing small issue
here and there...

How do i ensure that a textbox gets correctly populated...
i.e i have noticed that it is possible to enter the data with two or three
empty spaces in the beginning of the textbox..

Thanks again!

What does correctly populated mean?
If all you wish to do is assure that the data in that particular field
does not have any leading spaces, code that control's AfterUpdate
event:
Me.[ControlName] = LTrim(Me.[ControlName])

 

[Peter]

Thanks Fred, works prefectly!

Hi again.....i am almost ready with by database..just fixing small issue
here and there...

How do i ensure that a textbox gets correctly populated...
i.e i have noticed that it is possible to enter the data with two or three
empty spaces in the beginning of the textbox..

Thanks again!

What does correctly populated mean?
If all you wish to do is assure that the data in that particular field
does not have any leading spaces, code that control's AfterUpdate
event:
Me.[ControlName] = LTrim(Me.[ControlName])