Mid text box formating

[Wayne-I-M]

Hi

Maybe this can't be done without using S Lebans activeX
but worth a look anyway

I have a report that takes it's details from a query. Some one the report
boxes are calculated in the query like this

StartLess49To30: "49 to 30 days prior to departure, 60%. In your case this
is between " & Format(DateAdd("d",-49,tblEvents!EVTStart),"ddd dd mmm yyyy")
& " and " & Format(DateAdd("d",-30,tblEvents!EVTStart),"ddd dd mmm yyyy") &
"."

I would like the 2nd section bolding - thats the bit after "In your case...."

something like

.....to departure, 60%."& APPLY BOLD&" In your case this....

As you can see its the cancelation section of a holiday termms and condidtions

I know I could just split it into 2 calculations and bold the 2nd but was
just wondering if it is possible to apply formating mid way in a calculation

Thanks for any tips

 

[Allen Browne]

What version of Access?

In Access 2007, you can set a memo field to Rich Text. It's actually HTML,
so you can then insert some HTML tags like this:
="Show a <b>bold</b> word."

 

[Wayne-I-M]

Access 2003


--
Wayne
Manchester, England.

What version of Access?

In Access 2007, you can set a memo field to Rich Text. It's actually HTML,
so you can then insert some HTML tags like this:
="Show a <b>bold</b> word."

 

[Allen Browne]

You'll have to use a solution such as Stephen's:
http://www.lebans.com/mixbold-plain.htm

 

[Wayne-I-M]

Hi Allen

I have just tried that S Lebans code again and am getting the same problem -
I am sure that it me doing something wring.

But from what I see the Lebans code has failed to take into account the size
(height) of the text box containg the Bold/NoBold text. The can grow is not
acitivated by the code so the text overlapps the box below. - in the case of
well fitted boxes.

As I said I'm sure it's me doing something wrong with this. eg. If the
text font size is increased then you would still need to do this in the
design process which I did and also undid just to check.

Have reverted back to simply using 2 boxes just to get it done.

Many thanks for your idea.