format date field

[gersheff]

Is there any way to set a date field in a form that has the format of dd-mmm-yy or mmm-yy depending if the date is an estimate or a real date

ex) If estimate the user will input "Nov-04 ", and if a real date the user will input "12-Nov-04"

i will have a combo box whill allow to identify if the date is an estimate or not.

 

[Brian1960]

Switch on the Combo

You could switch the object visible when the user changes the combo setting. If Estimate the set Me.EstDate.Visible =True and Me.ActDate.Visible = False with the combo box OnChange and setting Actual then Me.EstDate.Visible =False and Me.ActDate.Visible = True

You end up with two form objects for the date field, and if you want you can leave them unbound so that you can treat them accordingly.

Hope it gives an idea

 

[gersheff]

but then how would it know which 1 to save to the table?