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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
Enforcing "required" on a control/textbox 2
Populating the data of two Textboxes into One textbox 11
Re-Insert Null value into database field 3
populate textbox 0
1 textbox populating 2 fields 7
Date of 1/14/2010 and on not working in form 2
Parsing a textbox entry 3

Back
Top