Tab Exporting

[Robert]

I’m trying to add a Tab command in a field for exporting purposes. I will be
pasting info from Access to an outside program and to move from field to
field it requires a tab after each entry.

Example (access)
Field 1 Field2 Field3
Name (TAB) Address

Outside Program
Field1 Field2
John (tab) Smith

I tried exporting to excel and then cut and paste this does not work even
with Field2 being empty. So I guess I’m looking for a hidden Tab command that
is universal or any suggestions that might help. Again I’m not looking for
tab Order in Access.
Thanks in advance

 

[John W. Vinson]

I’m trying to add a Tab command in a field for exporting purposes. I will be
pasting info from Access to an outside program and to move from field to
field it requires a tab after each entry.

I would strongly suggest introducing this tab character using the
Export specification, rather than trying to include it in your query.
Storing it in your Table is certainly NOT the way to go!

If you have trouble with the export spec, an alternative would be to
export from a Query not from your table. Include a calculated field
using the ASCII equivalant of the Tab character, Chr(9):

ExpField1: [Field1] & Chr(9)

in a vacant Field cell in your query.

John W. Vinson [MVP]