password date issue

[rob.low]

hi
what i have is a unbound text box that gets the hard drive number in to it.
and what i am trying to do is add the month and year to the end of the hard drive number

ie: hard drive numger is 12345678(i want the month and year shown here)
ie 12345678(1008) () is date

any help will be apprecheated

rob

 

[pbaldy]

FieldName & "(" & Format(Date(), "mmyy") & ")"

 

[rob.low]

thank you

hi paul

that worked a treat thank you

cheers
rob