Inserting tabs in varchar or text field

[Alan Z. Scharf]

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

 

[a a r o n . k e m p f]

you should store that stuff in seperate fields

 

[Tom van Stiphout]

On Thu, 26 Jun 2008 12:28:54 -0400, "Alan Z. Scharf"

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.