how do i print a date in a form in access

[Guest]

using windows xp and office xp, from the database we have been using for 4
years i have never been able to add the current date (todays date) into a
form,we use to send out statements any answers?

 

[BruceM]

Save the form as a report, since reports are better suited to printing. To
put the date onto the report, you could set the Control Source of an unbound
text box to =Date() if you want the current date to be printed whenever you
print the statement. If you want the statement record to include the date
the record was created, set the default value of the date field to =Date().
Just out of curiosity, what have you been doing about the date for the past
four years?

 

[Joxk]

using windows xp and office xp, from the database we have been using for 4
years i have never been able to add the current date (todays date) into a
form,we use to send out statements any answers?

If you enter the report in design view and create an unbound text box in the
report footer. In the text box type "=date()" this will put todays date on
the report.

hth

 

[Guest]

thank you for your answer,i didnt create our database the person that did
included a box to type the date in, finding this too labourious i stamp it in
with a hand stamp,it looks ok! having tried your sugestion in the form design
view, in several ways all i get is a hash sign with name! or nothing at
all.Which is the same as i have achieved in the past.I will carry on stamping
the date in i think.

 

[John W. Vinson]

thank you for your answer,i didnt create our database the person that did
included a box to type the date in, finding this too labourious i stamp it in
with a hand stamp,it looks ok! having tried your sugestion in the form design
view, in several ways all i get is a hash sign with name! or nothing at
all.Which is the same as i have achieved in the past.I will carry on stamping
the date in i think.

:-{(

Did you actually read the suggestion?

Access has two types of objects you can use.

FORMS are designed for on-screen use, for interacting with the data in
your tables. They are not ideal (or even very good) for printing.

REPORTS are designed to be printed to paper. If you are printing a
paper form, the Access tool that you want to use is a Report.

If you create a Report, you can use the toolbox to put a Textbox on
the report where you want today's date printed.

With the Report in design view, select that textbox; view its
Properties; and type

=Date()

into the Control Source property (first property on the Data tab).


John W. Vinson [MVP]