string value

[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

 

[John Smith]

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