Bolding a field within a report text box in Access 2010

I need to insert into my report the field holding persons names and their addresses from a table  into the middle of some other verbiage within a text box.  I need just the name and address to be bolded but can't figure out how to do that without making everything in the text box be bold.  I turned the format of the text box to Rich text but wasn't sure where to go from there.  Any one have suggestions.
MalawlessAsked:
Who is Participating?
 
Jeffrey CoachmanConnect With a Mentor MIS LiasonCommented:
1. You must be using the .accdb format
2. you must create a "memo" field to hold this data

Can you post the detail of this mysterious "Other verbiage"?
This must be memo data as well
Is it it two pieces, or is it all together and needs to be split..?

In other words post a sample of exactly what you have, then post a clear graphical example of the *exact* output you need.

Post a sample database and full explanations for its use...

In a very broad sense if the "Other verbiage" is also memo data, and is in two pieces, you should be able to get what you want like this
- Set the datattype of all 4 fields to:Memo
- Set the "Text  Format" property of the Name and Address fields to : Rich Text
- Make the Name and Address field Bold in the underlying table
- Do this on the detail format event of the report:
me.YourTextbox=[Verbage1] & " " & [The Name] & " " & [The Address] & " " [Verbage2]


There are other ways as well...
But again, we need a lot more info to give you a targeted solution...

JeffCoachman




JeffCoachman
0
 
Jeffrey CoachmanMIS LiasonCommented:
On second thought, try something like this:
Access-EEQ28227877--concatenate-.accdb
0
Cloud Class® Course: Ruby Fundamentals

This course will introduce you to Ruby, as well as teach you about classes, methods, variables, data structures, loops, enumerable methods, and finishing touches.

 
Jeffrey CoachmanMIS LiasonCommented:
produces something like this:
Output
0
 
MalawlessAuthor Commented:
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.
0
 
Jeffrey CoachmanMIS LiasonCommented:
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
0
 
MalawlessAuthor Commented:
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.
0
 
Jeffrey CoachmanMIS LiasonCommented:
<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
0
 
MalawlessAuthor Commented:
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.
0
 
Jeffrey CoachmanMIS LiasonCommented:
OK great...
keep me posted.

;-)

jeff
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.