Formatting Text Box

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Can't do by simple formatting, but can do with a control source expression:

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Join Fields 1
Format Query 2
formatting a number in a text box 1
Hello happy new year to all, Text box input for year of purchase 0
Format text box based on table field format 5
list box date column, number column formating 2
Daily Clock Rings 5
Convert Text to Date Month and Year 1

Back
Top