var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Is it possible to concatenate integer numbers and text? I am trying to concatenate a prefix text field (WO) with an AutoNumber field. I would like my output to look like this WO0000001.
If I use the following format, I receive this output WO1.
WO_Number: [WO_Prefix]& "" &[WO_Num]
If I use the format below, I receive this output #Error.
What the heck am I doing wrong?
"WO" & Right("0000000" & [WO_NUM],7)
"Lisa, in this house, we obey the laws of thermodynamics!" - Homer Simpson
"I have my standards. They may be low, but I have them!" - Bette Middler
"It's a book about a Spanish guy named Manual. You should read it." - Dilbert
XTreme VB Talk
OMG! It worked.
Thank you, thank you, thank you.
Log in with your username and password
Forgot your password?
Subscribe to dBforums Brief to receive special offers from dBforums partners and sponsors