Correct population of a textbox

  • Thread starter Thread starter Peter
  • Start date Start date
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!
 
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])
 
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...
 
Back
Top