Insert Data to Text Area

[fenhow]

Hi,

Running into a bit of a problem. I am creating a form that has base information. There are areas of the form that will be populated from specific fields in the database.

Is there any good way to accomplish this? I am trying to "insert" the appropiate data as show below. The text is standard for all reports and the BOLD CAPS is what I am trying to call from the DB.

THIS AGREEMENT is made and entered into on [NOW DATE] by and between [NAME] (herein after called “ Optionor” whether one or more), whose address is [ADDRESS], and [OTHER NAME] hereinafter called “Optionee

I guess what I am looking for is some kind of method similar to a mail merge with a word document (where you just insert the fields).

Thanks.

Fen How

 

[pbaldy]

Generally speaking, you concatenate the variable data in:

"THIS AGREEMENT is made and entered into on " & [FieldName] & " by and ..."

 

[fenhow]

Thanks, do I put that in a label, list box, ??

 

[pbaldy]

The technique can be used pretty much anywhere, with slight adjustments. Based on your description, I assumed you have it as the control source of a textbox, so it would be preceded by an equals sign:

="THIS AGREEMENT is made and entered into on " & [FieldName] & " by and ..."

 

[fenhow]

Great, I got that to work, any way I can make the fields from the DB bold? also anyway to auto insert the date?

Fen

 

[pbaldy]

The current date? The Date() function returns the current system date. As for bold, if you have 2007 there are some built in capabilities, otherwise you're looking at something like:

http://www.lebans.com/richtext.htm

I haven't used either, but Lebans' stuff is typically excellent.

 

[fenhow]

Thanks, any way I can format the NOW() from 9/4/09 to long date?

Thanks.

 

[pbaldy]

Have you looked at the Format() function?