Text date into date field

[harrisw]

Strange I know but can it be done

I have a combo box with dates in it. The combo box is linked to a table for its values which are "short dates" in the format

This value is then stored when the form is saved into another table again with the field set up as a short date.

When I try and save the form it comes up with something along the lines "you can't put a text field into a date field

I've checked all the field properties and they are all set to short date.

Is there a way around it? or I can put the date into a field which is purely text and convert it to a date before the form saves?

 

[Sharad]

Any particular reason you are using Combo Box for Dates? Try txt Box. That might do it. Keep us posted and Good Luck.

 

[harrisw]

sorted it.

I was using a combo bow that had specific dates in that users must enter.

What was happening however is that the key in the table was being put into the underlying table.

Because the key isn't a date its just an integer it was causing problems.

I've now got it so that the form save references the .text of the combo box and therefore saves the date to the table.