Unbound text box truncates leading zeros

[brharrii]

I'm using an unbound text box to combine the values of two fields in order to create an ID to be used in controlling forms. One of the fields (DocumentID) is an auto number that is formatted to always produce a 5 digit number (00000). When I set the control source to =[documenttypecode] & [documentID] however, the leading zeros from the documentID field are truncated.



Is it possible to change this so that the full document ID is displayed? once combined the unbound text box should display an ID with 4-6 leading alpha characters followed by 5 numerics.

Thanks!

[Dal Jeanis]

Try the format function in your concatenation, something like this

=[documenttypecode] & format([documentID],"00000")

[brharrii]

Perfect, thank you

[Iain]

This looks like a solution to my own problems. Does anybody have any examples of code applying the format function as suggested?
Slainte

[June7]

There's an example in post 2. Search Access Help or the web for more info.