stupid question - Dates in form...

[mtairhead]

I've searched these forums, but I haven't found anyone as clueless as I...

All I want to do is put something in the "Control Source" of an empty field in a form to create a date... Specifically, in the following format: MM/DD/YYYY

I know this has got to be easy, but I can't figure it out. I'm an idiot...And so is Mr. Clip-It.

Andrew

 

[WayneRyan]

mtairhead,

Don't use the ControlSource (unless you WANT to bind the value to a
table column). Try using the DefaultValue property of the field in question.

Wayne

 

[mtairhead]

Ok. That's actually what I started off doing.... The reason I feel so stupid asking this question is...Well... What do I put in that default value field, to make the date appear in "MM/DD/YYYY" format?

Andrew

 

[Rich]

"MM/DD/YYYY" in the Format property of the control

 

[mtairhead]

Ok...So, I have "Date ()" in the default value property of the field.
I also have "MM/DD/YYYY" in the format value....And nothing is appearing in the box when I display for form... What am I doing wrong?

Andrew

 

[Rich]

It won't display until you start adding records

 

[adevera]

mtairhead

check the value of control source of the textbox...it should be =Date()

i.: controlsource=Date()

I'd seen what you write here as "Date ()"...no space between the word date and ()...

Even you dont add or edit a record... this will automatically displayed on your form once it is open or loaded...