string value

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

smk23

I am using a loop to iterate through a list and sometimes need one vbTab in
the code, other times need (2): vbTab & vbTab :

For each Tcolumn in rs.Fields

strMy=strMy & vbTab & column.Name & vbCrLf

Next Tcolumn

How can I do this? If I use a variable, it is not recognized by Access as
the vbTab code.

Thanks!
Sam
 
strMy=strMy & vbTab & iif(Needs2, vbTab, "") & column.Name & vbCrLf

Replaces Needs2 with an expression that is true when you need two tabs.

HTH
John
##################################
Don't Print - Save trees
 
Back
Top