I need to combine a record number field and a user ID field to create one unique field. For instance...Record 0001, User All2B, needs to return A112B0001. Help?

Hi
use the "&" ie concantenation operator. This will combine the two feilds
eg [first name]&[surname]
This should solve your problem
varun

That helped! Now, the problem I am having is that the Record Number is an autoupdate numeric field. When I combine it to the User ID text it drops the leading zeroes in the Record Number. I tried setting the field format and input mask to ##########. I am still unable to combine the fields with the zeroes in tact.

Did you set the format in the combined field or the autonumber field? I think if you do the latter, the format will carry through to the combined field.

HTH,
David R

To get numeric values to show as fixed length fields with leading zeros, use the Format() function.

Format(RecNum,"0000") & User