using vbTab

  • Thread starter Thread starter frank
  • Start date Start date
F

frank

I have a text box that displays text that has been
formated with various vbCrLF and vbTab. When the text is
displayed in the text box, the occurances of the vbTab
show up as boxes (square). How do I get rid of the boxes
that are showing up as placeholders for vbTab in the text
box?
 
frank said:
I have a text box that displays text that has been
formated with various vbCrLF and vbTab. When the text is
displayed in the text box, the occurances of the vbTab
show up as boxes (square). How do I get rid of the boxes
that are showing up as placeholders for vbTab in the text
box?
Click to expand...


Use the Replace function to change vbTab to A buch of
spaces.

=Replace(thefield, vbtab, " ")

Just make sure the name of the text box is not the same as
the name of the field.
 
You can't use tabs to get columns in an Access textbox. You can do it by
adding "padding" spaces - as the other respondent said - but only when the
textbox uses a non-propertional font like Courier. You can't use spaces
successfully, with a proportional font like Arial.

HTH,
TC
 
Back
Top