Correct population of a textbox

P

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!
 
F

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!
Click to expand...

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])
 
P

Peter

Thanks Fred, works prefectly!

fredg said:
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!
Click to expand...

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])
Click to expand...
 
Top