Need help with reports

[Shyguy]

Is there any way to get a for to act like a merge document in Word,
where the text on the same line as a field would stay close to the
text beafore and after the field?

[fredg]

On Sat, 19 Jun 2004 22:04:49 GMT, Shyguy wrote:

Is there any way to get a for to act like a merge document in Word,
where the text on the same line as a field would stay close to the
text beafore and after the field?

In an unbound control (in a Form or in a Report):
="Please remit " & Format([AmountDue],"#,###.00") by
Format([DueDate],"mmmm dd, yyyy") & " so that we may begin to process
your order."

will print out as:
Please remit $1,275.50 by June 28, 2004 so that we may begin to
process your order.
--
Fred
Please only reply to this newsgroup.
I do not reply to personal email.

[Shyguy]

On Sat, 19 Jun 2004 23:33:56 GMT, fredg <fg******@example.invalid>
wrote:

On Sat, 19 Jun 2004 22:04:49 GMT, Shyguy wrote:

Is there any way to get a for to act like a merge document in Word,
where the text on the same line as a field would stay close to the
text beafore and after the field?

In an unbound control (in a Form or in a Report):
="Please remit " & Format([AmountDue],"#,###.00") by
Format([DueDate],"mmmm dd, yyyy") & " so that we may begin to process
your order."

will print out as:
Please remit $1,275.50 by June 28, 2004 so that we may begin to
process your order.

Thanks for the reply. I'm Trying to get the field to be a different
font and Bold. I tried different configurations of the above but to
no avail.

[Pieter Linden]

Shyguy <sh****@aol.com> wrote in message news:<8h********************************@4ax.com>. ..

Is there any way to get a for to act like a merge document in Word,
where the text on the same line as a field would stay close to the
text beafore and after the field?

Use a calculated control?

[fredg]

On Sun, 20 Jun 2004 01:53:24 GMT, Shyguy wrote:

On Sat, 19 Jun 2004 23:33:56 GMT, fredg <fg******@example.invalid>
wrote:

On Sat, 19 Jun 2004 22:04:49 GMT, Shyguy wrote:

Is there any way to get a for to act like a merge document in Word,
where the text on the same line as a field would stay close to the
text beafore and after the field?

In an unbound control (in a Form or in a Report):
="Please remit " & Format([AmountDue],"#,###.00") by
Format([DueDate],"mmmm dd, yyyy") & " so that we may begin to process
your order."

will print out as:
Please remit $1,275.50 by June 28, 2004 so that we may begin to
process your order.

Thanks for the reply. I'm Trying to get the field to be a different
font and Bold. I tried different configurations of the above but to
no avail.

Access, as shipped, does not support mixing formats within a control.
See:
http://www.lebans.com
to see if his Mixed/Bold Report method will be helpful.
--
Fred
Please only reply to this newsgroup.
I do not reply to personal email.

[Shyguy]

On Sun, 20 Jun 2004 04:32:32 GMT, fredg <fg******@example.invalid>
wrote:

On Sun, 20 Jun 2004 01:53:24 GMT, Shyguy wrote:

On Sat, 19 Jun 2004 23:33:56 GMT, fredg <fg******@example.invalid>
wrote:

On Sat, 19 Jun 2004 22:04:49 GMT, Shyguy wrote:

Is there any way to get a for to act like a merge document in Word,
where the text on the same line as a field would stay close to the
text beafore and after the field?

In an unbound control (in a Form or in a Report):
="Please remit " & Format([AmountDue],"#,###.00") by
Format([DueDate],"mmmm dd, yyyy") & " so that we may begin to process
your order."

will print out as:
Please remit $1,275.50 by June 28, 2004 so that we may begin to
process your order.

Thanks for the reply. I'm Trying to get the field to be a different
font and Bold. I tried different configurations of the above but to
no avail.

Access, as shipped, does not support mixing formats within a control.
See:
http://www.lebans.com
to see if his Mixed/Bold Report method will be helpful.

Thank you. I couldn't find anything by the name you mentioned, but
did find a sample database, with the code that seems to do what I
need. ;-)