Not for Rocket Scientists

[Candor Feg]

Please. If you are a rocket scientist, ignore this post.

I have a report.

For more information see:
http://www.google.com/search?hl=en&...crosoft+access+reports+for+complete+dumbasses

The values of field1 are numeric and can be positive or negative.

When the value of field1 is positive, I want to display fields 5 thru 10.
When the value of field1 is negative, I want to display fields 6 thru 14

How can this be accomplished.

http://www.google.com/search?source...LD:en&q=basic+problem+solving+for+total+jerks


Thank you

 

[Nikos Yannacopoulos]

If I weren't a rocket scientist, I would tell you to put the following
code in the detail section's Format event:

bShow = (Me.Contol1 >= 0)
Me.Control5.Visible = bShow
Me.Control11.Visible = Not bShow
Me.Control12.Visible = Not bShow
Me.Control13.Visible = Not bShow
Me.Control14.Visible = Not bShow

where ControlX should be replaced with the actual names of the controls
on your report. Note that I haven't included controls 6 through 10 in
the code, since they should be visible regardless.

Regrettably, being a rocket scientist, I can't tell you this!

Nikos

 

[PC Datasheet]

What do you want to do if Field1 is 0 or Null?

 

[Candor Feg]

Hmmm. I can definitely see that you are not a rocket scientist. I really
appreciate that.

What would I do if the field contained a banana?
I don't know. Fortunately I don't need to worry about such things.

 

[Candor Feg]

Thanks Nikos!

I wish you were around to help with some of my other questions, they were so
far above the heads of those who tried to answer them that they were out in
space!

 

[Nikos Yannacopoulos]

Thanks for being your usual rude self again, and making me search for
your previous posts, which I had not seen; at least now I can extend an
apology to Rick, Duane, Stephen, Larry and Doug (in random order) for
helping you out. Needless to say, had I seen those before, I wouldn't
have done it.

There's a lesson in it for you though: if you ask a question that makes
sense, in a nice way (you see, I mistook the rocket scientist part for
just an innocent joke), you're likely to get an answer.

For your information, all those people you were so rude to, have been
here for a long time, and have been a great help to numerous others (who
weren't rude, by the way!)... it's no accident most of them have been
granted the MVP title. You owe them all a big apology, following which
I'm sure you'll get good help here in the future, provided you respect
the rules of the newsgroups. On the other hand, if you're not prepared
to do that, I suggest you don't waste anymore time posting questions,
chances are you won't get answers.

Nikos

 

[Candor Feg]

Ah well. Hindsight is 20/20. I hope you have learned some lessons. This has
been my priveledge to give you the opportunity to hone your people skills.

At least you shown that a question can be answered without all the protocol
and gushing respect that some MVPs feel they are due.

 

[Sylvain Lafontaine]

Hum, is it because that rocket scientists have put a chimpanzee in space
that you dislike bananas?