Making Lines and design boxes visible on printing in word

Dear all:

Thanks for the help.I figured out how to output to snapshot.I also put some
expressions to control the data.Now my question is What is the right syntax
to use Nested if statements.I used this and it does work but for some reason
a small square box is displayed against field c3,c8

=IIf([c7]="N/A",IIf(IsNull([c3]),[c14],[c3]),[c7]).Is this anyhting?Also are
the functions Lcase and Ucase
be applied throughout the report rather than individual field?

Marshall Barton wrote:
So how do I achieve it.WOW!!! I have been working all this while to develop
this application learning access for quite sometime now.and now after all the
work I did on the import of fields I realise the end layout does not look
impressive as Iw ant it to be.Please can u help me to design layout as
desired!!

Id the only reason your are trying to send it to Word so you
can move things around? Or do you need to add/edit the data
in the report?

We can help you work on the report's layout, but we need to
know what problem you are trying to deal with.


--
Message posted via http://www.accessmonster.com

Prachi via AccessMonster.com wrote:
Thanks for the help.I figured out how to output to snapshot.I also put some
expressions to control the data.Now my question is What is the right syntax
to use Nested if statements.I used this and it does work but for some reason
a small square box is displayed against field c3,c8

=IIf([c7]="N/A",IIf(IsNull([c3]),[c14],[c3]),[c7])
Is this anyhting?

Ignoring your cryptic names, I don't see anything wrong with
the syntax of that expression.

The small square box is how most fonts display invalid
characters, e.g. a tab, nl, etc. Depending an the program
where the data was entered, user can enter a new line
sequence in a text string by typing Shift or Control +
Enter.

Also are the functions Lcase and Ucase
be applied throughout the report rather than individual field?

A function only operated on its arguments. They have no
effect on other areas of a report.

--
Marsh
MVP [MS Access]