By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,700 Members | 1,451 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,700 IT Pros & Developers. It's quick & easy.

Need help with reports

P: n/a
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?
Nov 13 '05 #1
Share this Question
Share on Google+
5 Replies


P: n/a
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.
Nov 13 '05 #2

P: n/a
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.
Nov 13 '05 #3

P: n/a
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?
Nov 13 '05 #4

P: n/a
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.
Nov 13 '05 #5

P: n/a
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. ;-)
Nov 13 '05 #6

This discussion thread is closed

Replies have been disabled for this discussion.