By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,806 Members | 1,506 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,806 IT Pros & Developers. It's quick & easy.

Frustration with report !

P: n/a
Why does access suck so bad?

I have an Access 97 report that I want to duplicate to provide
alternate information but use the same label printer.

I designed the database and the original report. They work just fine.

However now we have to provide other information that is not included
on the current label. So... I copied and pasted the report and renamed
it. I went into the design and changed the fields and labels I need.
Changed the source query as well.

The query works fine. When I open the report, some label boxes don't
even show up and the text box I want in the center of the label shows
up on the far right side!

So frustrated. Why does simple stuff like this have to be so
rediculous? I can't be making this harder than it is.

Dec 21 '06 #1
Share this Question
Share on Google+
1 Reply


P: n/a
"Bruce Lawrence" <BL*****@gmail.comwrote
Why does access suck so bad?
Would you go to the mothers of a child of which she was obviously fond, and
begin a plea for assistance by asking, "Why is your baby so ugly?"?

As we don't know any details of what you have, what the printer driver does,
and other "small items" that might affect the output, it's unlikely that you
have done more than blow off some steam and irritate some people.

What I can say is that I've been using Access since January 1993, and Access
reporting has never arbitrarily made a label Control or a Text Box
invisible, nor has it arbitrarily relocated a Control that I properly placed
in design view. Thus, I doubt you are experiencing a general defect in
Access that affects all copied and modified Reports.

Check the location of the Text Box in design view. Make certain that it
doesn't extend the whole width of the label, and just has inadvertently been
set to "right justify" or that the Control Source wasn't changed to a
numeric field that would automatically right justify.

Check the Visible property of Controls that aren't showing up.

If their CanShrink property is set to Yes, and there's no other control
overlapping height on the line, then examine the data retrieved for that
Record because empty ControlSource may cause it to shrink away.

And, in response to your last rant, "simple stuff" in Access has never
seemed "so ridiculous" to me; it's always seemed rather, er, "simple". I
have observed many people blaming the tool when that was not the source of
the problem, but I don't know enough about your situation to say that's the
case. I will say that in every case I remember where someone has said the
equivalent of "I can't be making this harder than what it is." that was
exactly what was going on.

I hope my suggestions were of some help. I'd be happy to offer other
suggestions if you have additional information that might be of help in
helping, provided you don't start out by calling my baby ugly.

Larry Linson

I have an Access 97 report that I want to duplicate to provide
alternate information but use the same label printer.

I designed the database and the original report. They work just fine.

However now we have to provide other information that is not included
on the current label. So... I copied and pasted the report and renamed
it. I went into the design and changed the fields and labels I need.
Changed the source query as well.

The query works fine. When I open the report, some label boxes don't
even show up and the text box I want in the center of the label shows
up on the far right side!

So frustrated. Why does simple stuff like this have to be so
rediculous? I can't be making this harder than it is.

Dec 21 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.