Date Format Problem in Form

G

Gina

Hi

I am trying to display a date like 04.05 (standing for april 2005)

I have changed the date from date,short to this format in the MOT field of
the table CAR
so it changed from "dd.mm.yyyy" to "mm.yy"

In the table itself it is now stored mm.yy ... but in the form it is still
showing the dd.mm.yyyy format

tried this

TÜV.Text = FormatDateTime(TÜV.Value, "mm.yy")

but get errors... how can I make sure that a text is going to be of the
mm.yy format ?

Thanks
Gina
 
S

Steve Schapel

Gina,

Either of these...
1. Set the Format property of the TÜV textbox on the form to "mm.yy"
2. Use a calculated field in the Query that the form is based on,
like this:
MY_Date: Format([TÜV],"mm.yy")
... and then replace the TÜV control on the form with a textbox bound
to the MY_Date field.

For the record, "in the table itself it is now stored mm.yy" is not
correct. Formatting only changes the appearance, and does not affect
the actual value stored. In the table itself it is always stored as a
number, being the number of days since 30-Dec-1899.
 
Top