Can I have Multiple fonts per formula in crystal reports?

Can I have Multiple fonts per formula in crystal reports?

The problem is that I have this formua:
"Member #:  "+ToText (Truncate ({Customer.ScanID}),0)+"  " +NumberToCode39 ({Customer.ScanID},0 )

AND I need to use a Barcode font for NumberToCode39 ({Customer.ScanID},0 ) BUT regular Arial font for the rest.

The reason is that I want to use the format field properties to center the entire formula... so if you can think of another way to do this please let me know.

Thanks,
John
LVL 3
jdraggiAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Mike McCrackenSenior ConsultantCommented:
No you cannot.

However, you can do the following.

Create a formula - MemberNum
"Member #:  "+ToText (Truncate ({Customer.ScanID}),0)+"  "

Create another formula - MyBarcode
NumberToCode39 ({Customer.ScanID},0 )

Add a textbox to the report where you want this information.
Drag MemberNum into the textbox
Drag MyBarcode into the textbox.

They can now be formatted separately but will still look like a single formula on the report.

mlmcc

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
jdraggiAuthor Commented:
Thanks!

It took me a minute to figure out that once you drop the item in the textbox you have to double click on the textbox before you can select the formula inside it and then right click it to get its font properties and not the properties of the combined textbox.

Thanks again!
--John
Mike McCrackenSenior ConsultantCommented:
Thanks for that info.  I haven't used the tip since I learned it here and didn't know how to access the individual pieces.  I'll include that next time.

mlmcc
Mike McCrackenSenior ConsultantCommented:
Glad i could help

mlmcc
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Fonts Typography

From novice to tech pro — start learning today.