vbTab display issue

  • Thread starter Thread starter smk23
  • Start date Start date
S

smk23

I am using vbTab in a string expression:
stringA & vbTab & stringB

THe result is saved and displays on a report. Problem is, instead of a
space, I get a box on the report (where the tab should be). Is there a way to
get around this?

Thanks
 
It would appear the string is being created in a query. Queries do not
understand VB constants. There are two possible solutions.
One would be to use the Asc represtation of a tab character.
stringA & Chr(9) & stringB
The other would be use two fields in your query, one for A the other for B
and do the concatenation in the report's control
=[FldA] & vbTab & [FldB]
 
smk23 said:
I am using vbTab in a string expression:
stringA & vbTab & stringB

THe result is saved and displays on a report. Problem is, instead of a
space, I get a box on the report (where the tab should be). Is there
a way to get around this?

Thanks
Click to expand...

Tab will not display in an Access TextBox.
 
Back
Top