Re: Add ONE variable word to report header

Tech-Archive recommends: Fix windows errors by optimizing your registry

Thanks SO much, Marshall! This works like a gem, even on my "problem child"
report. This is EXACTLY what I was hoping to do, because it is easier than
requiring the user to type or paste the word "revision" four separate times
for the four reports.

Thanks for sticking with me till I got it.

Ann

Marshall Barton wrote:
="Report of whatever this is " & IIf(MsgBox("Is Revision",
4) = 6, "<Revision>", "")

The missing quote was between "Is Revision and the comma.

The reasons I suggested using the MsgBox instead of a prompt
string is because the Message box can be made to use Yes and
No buttons and because the user does not have to type
anything.
Ah, now that I look at things again (I was pretty tired on Friday afternoon)
I see that I DIDN'T use your solution. I used the one I linked to in my 2nd
[quoted text clipped - 43 lines]
would need to use Klatuu's idea, which, except for your lack
of VBA skills, is better all the way around.

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-reports/200603/1
.

Quantcast