I have a problem...

How do you get Access 2000 Reports to recognize tabs? These are tabs in word processing terms as in when you press the TAB key on your keyboard.

In a query that I made, I have a field that was formed from the concatenation of several other fields. I used CHR(9) to insert a TAB between each field. It looks like a square box in the result.

However, when I print to a report, it does not recognize the TAB and simply puts a space in between each field.

If I copy and paste the results from my query into a text editor, it does recognize the tabs.

I can't find a solution to this anywhere! Please help. Thanks.