Inserting tabs in varchar or text field

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Alan Z. Scharf - 26 Jun 2008 17:28 GMT

Hi is there a way to insert tabs into SQLServer table data to get data to
appear tabbed columns in Access 2003? forms and reports

For example:

1. Current storage in database table:
------------------------------------
03/31/1992 US$
05/31/2004 EUR
03/31/2006 JPY
06/30/2007 Class S
03/31/2008 SGD

2. Desired storage for forms and reports
-----------------------------------------
03/31/1992 US$ 05/31/2004 EUR
03/31/2006 JPY 06/30/2007 Class S
03/31/2008 SGD

3. I know there is combination ALT-RETURN or ALT-ENTER for inserting new
lines. That's how I got vertical listing in (1) above.

4. Is there some equivalent key combination that would insert a tab
character the same way - either via an access form, or directly into a
table, without putting a little square in between the tabbed sections?

Thanks very much.

Alan

Reply to this Message

a a r o n . k e m p f @ g m a i l . c o m - 28 Jun 2008 16:03 GMT

you should store that stuff in seperate fields ;)

> Hi is there a way to insert tabs into SQLServer table data to get data to
> appear tabbed columns in Access 2003? forms and reports
[quoted text clipped - 25 lines]
>
> Alan

Reply to this Message

Tom van Stiphout - 03 Jul 2008 05:26 GMT

You are mixing data storage with presentation.
The former should be as raw as possible, for maximum performance.
The latter takes care of formatting.

Down the road you will likely regret that you are storing multiple
data elements in a single field.

-Tom.

>Hi is there a way to insert tabs into SQLServer table data to get data to
>appear tabbed columns in Access 2003? forms and reports
[quoted text clipped - 25 lines]
>
>Alan

Reply to this Message