>>Hello all,
>> I have a form to add new products to the inventory. On that form I have 2 text boxes(one for order date, one for receive date).
>> I have to compare them, if the receive date less than the order date, I like to set them to something like "--/--/--" or "--/--/----" so I can enter the date I want.
>> When I try thisform.text1.value = date() I always got the current date, from there I can change into the date I want.
>> Is there any way that we can set up the date without numbers like I said above? Anybody has this experience?
>
>>>Set your date textbox's value in the property sheet to be {}, any empty set >>of curly braces.
>
>Hi Fred,
> On the format of the Textbox's Builder, I already chose datatype "Date" for the textbox so the textbox always has format as "--/--/--" whenever the form load. When I enter the "receive date" less than the "order date", I set up an error message and I like to have the textbox's format go back to the first time like "--/--/--" so I can enter a different date.
> Any ideas?
> Hobby.
At the place in the code that you do your error message, reset that controls ControlSource (meaning the variable or table.field) to the {} empty curly braces. Refresh the control, if needed.