On May 30, 11:27 am, "Jeff Boyce" <nonse...@nonsense.com> wrote: Jim I'll suggest that you post your new questions as new questions. If you leave them embedded "down-thread" like this, you won't get as many eyes on them... nor as many brains! Regards Jeff Boyce Microsoft Office/Access MVP "JimP" <hamj...@new.rr.com> wrote in message news:1180541267.028034

Thanks, Jeff -- I think I'm closer. I confess to being a newbie when it comes to using functions in Access. If I misunderstood your advice below, I apologize. I didn't have any luck with the CStr() function, but I finally got my form to look as desired by putting the following in my Control Source for the field: =Format([Figure Identifier],"0000000" & [Description] & ".eps"). So far, so good

I'm guessing that the Figure Identifier field is a numeric field, and it has some custom formatting to give it the leading zeros. If that is the case, duplicate the formatting in the concatenation expression. "JimP" wrote: I'm working on creating a database that pulls data from three fields and concatenates the results into a fourth. http://s22.quicksharing.com/v/5121074/ScreenShot002