Re: Add ONE variable word to report header

="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.
--
Marsh
MVP [MS Access]


Ann Scharpf via AccessMonster.com wrote:
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
or 3rd post. It was from jahoobob:

Place a Text Box in the report where you want the note. Set the Control
Source to [Enter note] (or whatever message you want.) When the report is
opened the user will be prompted "Enter note"

I had tried yours and it didn't work for me ... I assume because of the
quotes problem you refer to here. Can you tell me how to fix the quotes and
I'll try your method again?


Marshall Barton wrote:
Comments inline below.
Actually, I didn't go back into my database but cut & pasted those lines out
of Klatuu's earlier post. The lines that ARE in my open event are:
[quoted text clipped - 7 lines]
This is the ONLY change that I have made to my report, so if I remove them, I
am just back to the original version which, as I said, did open just fine.

The reason I want you to actually remove that code is to
double check that something else isn't getting in the way of
chasing down this problem. Logic may say it can't happen,
but I really want to make sure that the above perfectly
sensible code is somehow blowing up the whole report.

I did use your "quick and dirty" method of adding a text box with a control
source to prompt the user to add the word REVISION. This worked on three of
my four reports. The last report is significantly more complicated than the
others. (It's a composite of four unbound reports.) When I try to add the
field with control source to this report, Access doesn't print the word
REVISION in the header but the word ?NAME.

If you got that to work anywhere, you must have fixed my
missing quote mistake. I don't see any reason for it to
work one place and not work in another. The only way I can
think of getting ?Name is if the quotes were wrong, so maybe
you didn't fix my mistake in the one that doesn't work.

So, I am trying to find a way to make this last report print the word
REVISION at the top of the first page.
[quoted text clipped - 3 lines]
made a copy of the report and switched the page header info to the report
header. Didn't have any effect.

I don't think that makes a difference, but if it did, you
would need to use Klatuu's idea, which, except for your lack
of VBA skills, is better all the way around.

.