Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Entering data into a form field

Status
Not open for further replies.

sqlwp

Programmer
Joined
Jan 23, 2004
Messages
24
Location
US
Is there any way to use a tab to when entering data in a form field?
 
Could you provide more detail for your question?
 
When I enter data into a form field on a form I would like to use the tab button to tab over and line up different lines. For example:
Line1 tab1data tab2data
Line2 tab1data tab2data
 
Never even tried but it sounds like you are trying to add more than one data element into a field. You should probably have a field on the form for each element and if you need them to be in one field in the database, concatenate them when you are writing the record.

Then you could put the pieces together Line1 = "tab1data" & Chr(9) & "tab2data"

Are you trying to create a tab delimited record?
 
By default MS Access does not allow a tab to be used as a part of the data. Tab moves to the next field Shift + Tab moves to the previous.

If the reason you want the tab embedded in the data is for exporting it to another application this can be handled with the export specification that Access can give you and the Tab is one of several options.


HTH,

Steve
 
This form field is a field that contains text that is printed in a report. I'm just trying to format the text when I enter it into the form field so that it lines up the way I want it to. Right now I'm using spaces to line the text up between lines, but if I could use the tab key to create space between words and line the text up it would be a lot easier.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top