Date in unbound textbox

[rob peterson]

I want to set the date in an unbound textbox to 01/01/1970

Properties format : mm/dd/yyyy

Properties data - default value: 01/01/1970 turns to 1/1/1970 or if I build
=01/01/1070 turns to =1/1/1970

Anyway, when I click the form, I get 12/30/1899 for some reason. How do I
set this default?

Form is to work with a query to determine beginning and ending range of
dates.

Ending date works with =Now()

Thanks.

 

[Guest]

Wouldn't it be easier to use a label? If not, you should be able to use
="01/01/1970" to keep the format.

 

[rob peterson]

I can see the ="01/011970"

I didn't understand what you meant by "label"

rob

 

[Guest]

In a form, one can show text with a "Label" or "Text Box". Labels are just
that, they show text only, and other than some special formatting and
general information, they are just text. If you use the form wizard, some of
your header information is in the form of a "Label."
A text box on the other hand, can show data from a table or show manipulated
data.
Depending on what you want to do or show on your form dictates which object
you will use.
In your case, if you want just the object to show "01/01/1970", then a Label
would work. If, however, you want to do something with the date (a
calculation, for example), you could use a text box and bind it to a date
field in a table or query.

hope this helps,