Hello,



One of my Access databases has a couple of text fields (imported data).



The problem is that there are TABs in the data.  Access displays them

as vertical bars.



I have two questions:



1) Can Access display them as TABS?



2) When using a form for data entry, can one enter a TAB?  (A 

carriage-return

is <CTRL><Enter>.



I really do not want to go to a fixed-pitch font and substitute spaces 

for TABs,

but it has to look better than then it does now.



Thanks

I'm pretty sure that the answer to both questions is 'no'.



If you can give us some higher-level info here on what what you're trying to

accomplish, I bet we can give you good advice on maybe a different way of

getting there.  Maybe you could break out the various bits of info that you

right now want to tab-separate into separate fields?  Maybe you could use

multiple columns in a combo or list box to get the output you need?



I've heard tell of VB programmers going to lengths like this to display

multiple fields in the same list or combo box, b/c the VB versions of these

controls don't natively support multiple columns like the Access ones do.

In those cases I believe they use a fixed font & then programatically figure

out how many spaces to tack on to the end of each component so it looks

reasonable.  That's a drag to have to do tho.



Cheers,



-Roy



-----Original Message-----

From: Wayne Ryan [mailto:wryan@a...]

Sent: Thursday, May 24, 2001 3:17 PM

To: Access

Subject: [access] TABs in Access Databases





Hello,



One of my Access databases has a couple of text fields (imported data).



The problem is that there are TABs in the data.  Access displays them

as vertical bars. 



I have two questions:



1) Can Access display them as TABS?



2) When using a form for data entry, can one enter a TAB?  (A

carriage-return

is <CTRL><Enter>.



I really do not want to go to a fixed-pitch font and substitute spaces for

TABs, 

but it has to look better than then it does now.



Thanks

Thanks Roy,



Sorry, Friday was a day off.



Essentially, this is a database of Software Test Procedures.

The four table columns are the Procedure, ExpectedResult,

ActualResult and PassFail.



The text for the Procedure, for example, may appear as

follows:



=================================================

1.<TAB>Depress Switch 'A'

2.<TAB>Toggle Switch 'B' to OFF

3.<TAB>Ensure that the following values are set:



<TAB>Sensor A<TAB><TAB>abcdefg

<TAB>Sensors B and C<TAB>hijklm

=================================================



Access displays it as follows:



=================================================

1.|Depress Switch 'A'

2.|Toggle Switch 'B' to OFF

3.|Ensure that the following values are set:



|Sensor A||abcdefg

|Sensors B and C|hijklm

=================================================



These text entities were created in Corel Word Perfect.

There is no standard formatting, as they were entered

by many different people.  They should appear the same

as the author originally entered them.



I do get the feeling that they will indeed be in a

fixed-pitch font with spaces replacing the TABs.



I have software that calculates the height of the controls

and the Form.Detail property.  Fixed-pitch should make

this an even more consistent calculation.



Oh well ... Just thought I'd give it a try.



Thanks again.