Date in unbound textbox


R

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.
 
Ad

Advertisements

G

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.
 
R

rob peterson

I can see the ="01/011970"

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

rob
 
Ad

Advertisements

G

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,
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top