Add today's date to a label report

  • Thread starter Thread starter LMB
  • Start date Start date
L

LMB

Hi Guys,

Beginner here. I have a report I created with the label wizard in Access
2000. It has 3 rows of fields. I want the current date added to each
label. I tried to add a text box and then typed Date () in the text box but
it didn't work. I guess that was wrong. <g> How can I do this?

Thanks,
Linda
 
In design view, you could have used Insert/Date and Time. Gives lots of
choices.

Anyway, you have a simple problem to fix if you already have the text box on
the report.

Two things.

1 - You're missing an equal sign.

2 - There is no space between a function name and the parentheses.

Make the text box's Control Source:

=Date()

Good luck.

Sco
 
Hey, both work! I like that insert date and time choice. I tried it both
ways and it worked. Who would have thought a wee little = sign and a space
would make that much difference but I think it was pretty good that I
remembered the rest <g>
Now, I have 2 new questions now that I have me new working text date box.

1. What are the pros and cons of both ways?

2. When I look at the design grid of the report the grid is about 2.5 inches
wide by 1 inch tall. The field or control boxes are about 2.3 inches wide
and centered in the design grid. When I drag the text box for my new date
field to the bottom and center it, when I look at the report in the design
view it's centered below the existing text boxes, when I look at it in the
print preview the date is to the left side. How can I center my new text
box?

Thanks,
Linda
 
Linda, Linda, Linda...

Any chance you live in Denver or can get here? You need to take a couple of
my Access classes! :-)

1 - As they say in the old country, "macht nicht." :-) If you remember the
syntax, feel free to do it by hand. If you don't, just remember the Insert
menu and it'll do the work for you.

Just two basic rules to remember right now. (There are many more to come
later. :-) One, whenever you put something into a Control Source of a text
box that is not a field selected from the dropdown list, it *must* start
with an equal (=) sign. Two, there is *never* a space between a function
name and the opening parentheses.

2 - In design view, select your text box. Then look at the format toolbar.
Click on the Center button. (Looks just like the Center button in Word,
Excel, PowerPoint, etc. :-)

Or, with the property box open and your text box selected, 3/4 of the way
down the list, look for the Text Align property and select Center from the
dropdown list.

Good luck.

Sco
 
Shucks, I'm about 5 states away in Ohio.

I figured out the center problem. I used the center text button which does
the same thing as your Text Align property instructions. Since the text
above it was L aligned, the centered text didn't look quite right on the
labels. I ended up putting the date on the right side and it looks visually
a lot better.

Thanks for my rules. I'll start a personal rules sheet for myself but I bet
I'll use that insert menu for a while. <g>

I really appreciate the help...
Linda
 
You're most welcome.

Glad you got it worked out.

Good to start a rules list. You'll thank yourself in the future.

Ohio isn't that far away. I've had people come from as far away a Jersey
Island (In the English Channel between England and France.) to attend my
classes!

If you're ever in Denver...

Sco

M.L. "Sco" Scofield, Microsoft Access MVP, MCSD, MCP, MSS, A+
Useful Metric Conversion #17 of 19: 1 billion billion picolos = 1 gigolo
Miscellaneous Access and VB "stuff" at www.ScoBiz.com
 
Back
Top