Formatting Text Box

I

ingalla

Can anyone tell me how to format a text box to display the following:-
RTA/CG/0000220/07

Where RTA/CG/ is text
0000220 come from field RTARef (How can i include the preceding zeros?)
07 is the year from the date field RTADate

Thanks
Andy
 
K

Ken Snell \(MVP\)

Can't do by simple formatting, but can do with a control source expression:

="RTA/CG/" & Format([RTARef], "0000000") & "/" & Format([RTADate], "yy")
 
Top