Changing font sizes in a textbox

[Sess]

I searched and did not find an answer so maybe this is something newish.
I have a textbox on a printed report made from contatenating some fields and what I want to do within the textbox is to have just a portion of the text print bold if it matches a certain condition.
Can I have the Control Source be something like
=Text1 & Text2 & iif(Text3="something", BOLD(Text3), Text3) & Text4...
is there a code like that or just in my wishes?

 

[HiTechCoach]

The bas news it that the standard text box does not support this.

The good news is that there are options:

1) use a Rich Text Format (RTF) control. Access 2007 has one. For previous versions see RTF Control (Click Here)

2) Try Mix Bold (Click Here)

Hope this helps ...

 

[wazz]

you could concatenate all the fields before Text3 into one textbox and all the fields after Text3 into another textbox and position Text3 as needed in between the other 2. then use conditional formatting on Text3. (format --> conditional formatting). might be tricky but possible.

 

[Sess]

Thank you HiTechCoach - I looked at those links you posted and the second link has provided me with a sample that I might be able to work with if I can get it to work on my application. They are in Access2000 and I am stuck using Access2003. Well it might not be stuck because Accees2007 seems to have mixed reviews.

Thank you Wazz - I did try to concatenate parts and then try to fit the separate text boxed together but the kerning in the fonts make this a nightmare, but at least it is a nightmare after trying it and not just on supposition.

I think that I will need to not be as fancy at the moment and just have a separate "alert" on the report to advise the reoprt recipient of the urgent elements if they exist with my IIF statement. iif(Text3="something", Text3, "")

 

[HiTechCoach]

if you are using 2003 then you can use any example in 2000 or 2002. The code should work. You can even use 2000 format database in 2003 without doing any conversion.

the reason all the example are in 2000 5ormat only is that they will work with 2000 and later versions

 

[gemma-the-husky]

you could find some little graphic icons/bit maps (stars/ticks etc) and set these as visible/not visible as required.

you could also make the whole text bold, or have a different backgorund (eg vbyellow) for certain detail rows - which would make it stand out. (but this wont help with managing selected portions of the text only)