can i put a string in DATE/TIME default value ?

[joe55555]

hello all,



i have a small software for my company i am only facing one problem in the DATE/Time Default Value

I try to writea string its says: "type mismatch"

i want when adding a new record to appear in the Date/Time fields the following format "MM/DD/YYYY"
i don't want it to appear when i click on it, i did this using input mask

I just want the default value to show like "MM/DD/YYYY" when a new record is added and the user choose a date it become the date he chose.

Thank you

[ssanfu]

Welcome to the forum

No, you cannot write a string to a Date/Time field default value.

Set the default value for the field to "Date()" (no quotes)

If you want to give a hint as to how the date should be entered, create a label, set the caption to "(MM/DD/YYYY)", Set the font size to something like 6 and place the label above or below the text box control for the date.

[joe55555]

ssanfu thank you.

i was thinking about something but i don't know if it can work.

if i add vba code testing if the filed Date/Time of the table is empty so this shows a Label "MM/DD/YYYY" on the TextBox in the Form
and if the field Date/Time of the table is not empty, so this will hide the label "MM/DD/YYYY" and the Date will appear in the textbox in the Form

is this possible to do ? if yes, can anyone please give me a hint of the code !?

thank you