View Single Post
  #1  
Old July 24th, 2007, 09:47 PM posted to microsoft.public.access.reports
bobojones
external usenet poster
 
Posts: 4
Default Control source in text box

I am using the following expression in a control source =[ClientDesignator]
& "-" & [CatDesignator] & "-" & [FunctionDesignator] & "-" & [Version]

When I run the report the data is correct but I would like the version to
show up as 0001 instead of 1. Is there a way to do this?

Thanks