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?

On Sat, 19 Jun 2004 22:04:49 GMT, Shyguy wrote:
[color=blue]
> 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?[/color]

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.

On Sat, 19 Jun 2004 23:33:56 GMT, fredg <fgutkind@example.invalid>
wrote:
[color=blue]
>On Sat, 19 Jun 2004 22:04:49 GMT, Shyguy wrote:
>[color=green]
>> 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?[/color]
>
>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.[/color]


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.

Shyguy <shyguy@aol.com> wrote in message news:<8hd9d0lt2kp0auf6gc38krkcmet7ofk1lu@4ax.com>. ..[color=blue]
> 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?[/color]

Use a calculated control?

On Sun, 20 Jun 2004 01:53:24 GMT, Shyguy wrote:
[color=blue]
> On Sat, 19 Jun 2004 23:33:56 GMT, fredg <fgutkind@example.invalid>
> wrote:
>[color=green]
>>On Sat, 19 Jun 2004 22:04:49 GMT, Shyguy wrote:
>>[color=darkred]
>>> 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?[/color]
>>
>>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.[/color]
>
> 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.[/color]

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.

On Sun, 20 Jun 2004 04:32:32 GMT, fredg <fgutkind@example.invalid>
wrote:
[color=blue]
>On Sun, 20 Jun 2004 01:53:24 GMT, Shyguy wrote:
>[color=green]
>> On Sat, 19 Jun 2004 23:33:56 GMT, fredg <fgutkind@example.invalid>
>> wrote:
>>[color=darkred]
>>>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.[/color]
>>
>> 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.[/color]
>
>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.[/color]


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. ;-)