formatting question

[crescent-centre]

I have a field document number which auto increments with a format 0000. I also have a revision field. I want to produce another field with a format 0000 Rev 1. I've entered control source as =[document]&" rev"&[rev] and want the result to be 0001 Rev A but the result drops any trailing zeros, ie 1 Rev A. How can I keep 4 digit format which works in the document number field?

 

[maxmangion]

use the format() function for example if you want a field displaying four digits:

=Format([Fieldname], "0000")