Help creating complex string - how??

[Guest_imported]

I am trying to create a string that combines multiple value types but have been unsuccessful. I just found this site so I thought I would see if any of you could help.

I want to create an ID that combines static text, a variable (looked up from a table), and a formatted number.

An example would be DV-FIN001:
I figure that I need to create a string in VB as a Public Function like this (not exact as I cannot get it to work):

strID = "DV-" & "[table_name]Category.value" & "000"

I would appreciate any thoughts you may have on solving this issue.

Thanks!

 

[SimonDavis]

try using '+'instead of '&'. Usually works for me.

 

[fredl]

I thought the way to put two strings together was

[field1]&""&[field2] or

="String"&""&[field2]
if you want a space between the field and string seperate the quotation marks with a space

hope that helps