Discussion Locked

Removing Tab Characters in Access 2k

0 helpful
6 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

We use a database program called Clientele. When we enter in our forms some data and use the TAB key to tab over some spaces, on the reports printed using Access 2000, those TABs come out as squares.
Is there a way in Access to prevent these squares from showing up, so the TAB spaces are correctly recognized as the spaces they are?
Know what I mean?
Thanks for any help you can provide.

6 replies

by borginva

Comment from BorgInva on 5/29/03:
Ron Raz,
I am having trouble with this programming, probably because I do not understand a single thing with it.
I copied the data in the moduel and created a query, but it deletes everything in my field.
Ihave table EVENT with field MEMO (Event.memo) and all entries have a TAB inserted (because we use that instead of ihtting SPACE a bunch of times). I just want to make it so when we print a repeort, it can somehow run this query which will replace, on the report, TABS with SPACES (1 SPACE for each TAB).
Can you help with this M$ function?
Thank you.

by borginva

Ron Raz,
I am having trouble with this programming, probably because I do not understand a single thing with it.
I copied the data in the moduel and created a query, but it deletes everything in my field.
I have table EVENT with field MEMO (Event.memo) and all entries have a TAB inserted (because we use that instead of ihtting SPACE a bunch of times). I just want to make it so when we print a rpeort, it can somehow run this query which will replace, on the report, TABS with SPACES (1 SPACE for each TAB).
Can you help with this M$ function?
Thank you.

This discussion is closed to new replies.