Is it possible to change a data type in a form?

[wedd]

Hi all, I would like to change a text field from date/time data type to a number field on a form. I've manage to change it in the table, but because I've created queries as well as expressions to the existing form; I was wondering if I could change one of the text fields from a date/time field to just a number field. Is this possible, if so, how can this be done?



Thanks for your contributions:friends:

[HiTechCoach]

Check the text box control's format property.

[Norie]

You could delete the existing textbox and add the field again.

Then it will have the properties you've set in the table.