Making Lines and design boxes visible on printing in word

[Prachi via AccessMonster.com]

Hi

I have created a report in access which is like a printable form.It is
populated with fields .The form needs to have lines(EX. Name:
__________________).I tried to place lines using the toolbox below each of
the fields.Also it has a design including color field rectangles.My problem
is on printing the document in word there are no lines seen neither are the
rectangles.so basically it is a plane page with text.Can you please tell me
what is the problem and which is the quickest and right way to achieve this!

thanks

 

[Allen Browne]

Marshall is right, and here's an extra trick for handling check boxes:
http://allenbrowne.com/ser-52.html

 

[Prachi via AccessMonster.com]

Hi

So does that mean the way the design of a report appears in the Print view of
the report in access can never appear the same way in the word..So what is
the best way to achieve the design as desired.the problem using PDF is that
it can not be edited.isnt it?.and what is the way to print it as PDF and will
my problem be solved then?

I have created a report in access which is like a printable form.It is
populated with fields .The form needs to have lines(EX. Name:

[quoted text clipped - 3 lines]

rectangles.so basically it is a plane page with text.Can you please tell me
what is the problem and which is the quickest and right way to achieve this!

The fundamental issue is that a report is a graphical object
intended for a peice of paper or monitor. The only parts
that can be exported is the data, so you might as well just
export the report's record source query.

Better to print the report to a pdf printer than to send it
to Word.

 

[Allen Browne]

Yes.

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

So does that mean the way the design of a report appears in the Print view
of
the report in access can never appear the same way in the word..So what is
the best way to achieve the design as desired.the problem using PDF is
that
it can not be edited.isnt it?.and what is the way to print it as PDF and
will
my problem be solved then?

I have created a report in access which is like a printable form.It is
populated with fields .The form needs to have lines(EX. Name:

[quoted text clipped - 3 lines]

rectangles.so basically it is a plane page with text.Can you please tell
me
what is the problem and which is the quickest and right way to achieve
this!

The fundamental issue is that a report is a graphical object
intended for a peice of paper or monitor. The only parts
that can be exported is the data, so you might as well just
export the report's record source query.

Better to print the report to a pdf printer than to send it
to Word.

 

[Prachi via AccessMonster.com]

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!!

Yes.

So does that mean the way the design of a report appears in the Print view
of

[quoted text clipped - 20 lines]

 

[Allen Browne]

If you don't need to edit the document in Word, export a Snapshot or PDF
instead.

If you do need to edit the document in Word, you will need to use the tricks
such as fudging the lines with the underscore character.

An alternative might be to create a merge document in Word the way you want
it to look, and merge the results of a query from Access.

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

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!!

Yes.

So does that mean the way the design of a report appears in the Print
view
of

[quoted text clipped - 20 lines]

Better to print the report to a pdf printer than to send it
to Word.

 

[Prachi via AccessMonster.com]

I do not quite get it.Can you please elaborate.I appreciate it!! thanks

If you don't need to edit the document in Word, export a Snapshot or PDF
instead.

If you do need to edit the document in Word, you will need to use the tricks
such as fudging the lines with the underscore character.

An alternative might be to create a merge document in Word the way you want
it to look, and merge the results of a query from Access.

So how do I achieve it.WOW!!! I have been working all this while to
develop

[quoted text clipped - 12 lines]

 

[Marshall Barton]

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.

 

[Allen Browne]

Might leave you to research this further.
You have all the suggestions I have to offer.

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

I do not quite get it.Can you please elaborate.I appreciate it!! thanks

If you don't need to edit the document in Word, export a Snapshot or PDF
instead.

If you do need to edit the document in Word, you will need to use the
tricks
such as fudging the lines with the underscore character.

An alternative might be to create a merge document in Word the way you
want
it to look, and merge the results of a query from Access.

So how do I achieve it.WOW!!! I have been working all this while to
develop

[quoted text clipped - 12 lines]

Better to print the report to a pdf printer than to send it
to Word.

 

[Prachi via AccessMonster.com]

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]

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.