Set a format with code

[Nic]

Hi,
How can i set the format of text using some code in the control source of a text box?

Ill try and explain:
I have a textbox (a) that creates a string of data by 'adding' together data in a variety of other text boxes (b&c).
As such, my control source for text box (a) reads somthing like this:

="91" &[TextBoxB] & "10" & [TextBoxC] & "90"

The above results in my text box 'a' containing the info within text box B&C separated by the numbers in "".

Can i specify in the above the format which should be applied to TextBoxB and TextBoxC. Somthing such as:

="91" &[TextBoxB, Format mmyy] & "10" & [TextBoxC, format 000] & "90"

The above doesnt work, but i hope it may help explain my desire,

Many thanks in advance for any assistance,

 

[John Big Booty]

Have a look at the Format Function (with Dates)

 

[Nic]

Hi,
Thanks for guidance, but still struggling with this.
Iv tried all sorts of variable that i can think of from the link you have provided but nothing seems to work.
Could you spell this out for me?!?

Greatly appreciated,

 

[John Big Booty]

Have a look at the DateSerial() function too that might be better

 

[Nic]

Excellent - sussed it!!
Thanks for the help!