Bolding a field within a report text box in Access 2010

Simple enough, see this article http://office.microsoft.com/en-us/access-help/insert-or-add-a-rich-text-field-HA010014097.aspx

On second thought, try something like this:
Access-EEQ28227877--concatenate-.accdb

produces something like this:

Awesome.  I didn't think to put my verbiage in fields.  My report looks more like this.

="On the 22nd of April, 2012," & " " & [The Name] & " " & [The Address] & " " & "in the county of Wyandotte......"

I will give this a try.  Looks very promising.

Then give this a whirl...
(No extra fields needed in the table)

You could probably do this in VBA as well, but that might just complicate things beyond what you need here...

Have Fun!
;-)


JeffCoachman
Access-EEQ28227877--concatenate-.accdb

Here is one problem I am having. My table is not letting me make certain fields bold and others not.  I have compared my properties with your and don't see anything different.  Could this be something in options?  Because mine didn't come through on report as bold.  

Also a little bit of wrapping problem of the text.  My verbiage is several paragraphs but I will play with that tomorrow.  Thanks for the help.

<My table is not letting me make certain fields bold and others not. >
That is not how memo field and rich text work... By default, you have to select the text characters individually, then make them bold, there is no easy way to make an entire column bold in one shot.

That is why they created rich text, so that you could format different characters differently in each record (in the same field.)

This is why I really don't like doing things like this...too much trouble...
Because then you have to do more jerking around if they then want some fields blue and others red, then some Italic, then some Bold and underlined, then some 20Pt,,Bold,Underlined, Italic and Purple...ect

To do what you are asking here (make the entire field Bold for both fields for all records), ...then do this...
Make all your fields "Text" datatype
Do something like this in a query:
SELECT ID, "<b>" & [TheName] & "</b>" AS BoldName, "<b>" & [TheAddress] & "</b>" AS BoldAddress
FROM YourTable;

This inserts the HTML Bold tags around the field.
Then make this query the source for the report
The do your concatenation in the report, but use a textbox with the Text format property set to "rich text"

see this third sample
(test it by adding more names and addresses to the table)

JeffCoachman
Access-EEQ28227877--concatenate-.accdb

Ok so I think I have it.  Looks like I need to learn a little a bit of HTML and I will be set. I know SQL but not HTML.   Always something to learn.That is the other problem these will have to be local tables not linked SQL tables.  That's ok.   Realized part of my problem is the database this is in is still set to 2000 maybe why the other thing last night wasn't working.    Thank for your help - I am confident with this knowledge I can make this work.

OK great...
keep me posted.

;-)

jeff