Formatting Text Box ingalla 30.09.2006 20:35:01 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

Re: Formatting Text Box "Ken Snell \(MVP\)" <kthsneisllis9[ at ]ncoomcastt.renaetl> 30.09.2006 21:07:27 Can't do by simple formatting, but can do with a control source expression: ="RTA/CG/" & Format([RTARef], "0000000") & "/" & Format([RTADate], "yy") -- Ken Snell <MS ACCESS MVP> "ingalla" <ingalla[ at ]discussions.microsoft.com> wrote in message news:34522A18-D71A-4DF1-AC14-A69F5A458D6A[ at ]microsoft.com... [Quoted Text] > 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