Text Box troubles displaying text

[Guest]

I am reading in a text file that has columns of numbers that I want to
display in a multi-line TextBox. Now, the standard Access Textbox does not
seem to fill the bill, but I would use it for this purpose if someone would
show me how to make sure that the columns of numbers read in from the text
file all line up right.

I am having the same trouble when trying to use the MS Forms 2.0 TextBox.
Again, here is what the display looks like:

PHONE: (410) 775-2513
FAX: (410) 875-2009


Invoice 100383

Date:: 6/21/2007
Transaction 6/17/2007
Elk Run Vineyards
15113 Liberty Road
Mt. Airy, MD 21771


Sales: Taxable Items
Quantity Description
Unit Price Extended Price


1 CABERNET SAUVIGNON AMER 04
$22.50 $22.50
1 CHAMPAGNE 2000
$24.99 $24.99
1 CABERNET SAUVIGNON L TAVERN 01
$25.00 $25.00


3 Wine Items
Taxable SubTotal: $72.49

0 Other Items

3 Total



$3.62


Taxable Total: $76.11

Sales: Non-Taxable Items

Quantity Description
Unit Price Extended Price

1 CORK PULLER, 3 IN 1
$3.95 $3.95

1 GIFT CARD PURCHASE
$25.00 $25.00
1 GIFT CARD REDEMPTION
($11.00) ($11.00)


Non-Taxable Subtotal: $17.95





I set the wordwrap to no. I have looked at the data as it comes into my code
and the columns seem to be lined up correctly. Is there any other way of
displaying text files from within Access Forms if these items don't do the
job? Any help is appreciated. Thanks.

 

[Douglas J. Steele]

What you're trying to do really isn't something Access was designed to do.

It might be possible to use an RTF control (setting the font to a
non-proportional font such as Courier), but even that might not work.

 

[Peter Hibbs]

Ed,


A Flex Grid Control will probably do what you want. Have a look at -

http://www.rogersaccesslibrary.com/Otherdownload.asp?SampleName='Flex Grid Demo.mdb'

for some examples.

Peter Hibbs.