Spacing problem

P

Phil

Hi,

I have a format problem which I don't understand. I have
the following:

Tables:
Number_of_columns: one field per record
"count" with values 1-15
Lines: two fields per record
"count" value within 1-15 range
"Lines_format" a text field with any number of
vertical bars and spaces

Form:
Combo box: cboNumber_of_columns
SELECT Number_of_columns.count, Lines.Lines_format
FROM Number_of_columns INNER JOIN Lines ON
Number_of_columns.count = Lines.count;

After update event
Me.txtLines = Me.cboNumber_of_columns.Column(1)

text box: txtLines unbound text box

In theory when I click on the combo box and select a value
(1-15) the text box is to display the Lines_format. It
does, but the spacing is not correct. The vertical lines
are there, but there are twice the number of spaces. The
font and font size are the same in this form as they are
in the form where the "Line_format" were created.

Any ideas?

Thanks,
Phil
 
Top