Formatting text within formula in forms

For ideas, tips and tricks and comments on using or creating MoneyWorks Forms (invoices, statements, labels etc.),
Forum rules
This forum is not the official Cognito Software support channel for MoneyWorks. If you need help from Cognito, then please contact us (or your local regional support representative) directly using the contact information on the Support page of the web site.

Please try the search facility before posting a new topic to see if your topic has already been covered.

If you do post a new topic, it's a good idea to choose a Topic Subject that it a bit more informative than "Help!" or "A problem". If your topic is actually recognisable by people scanning the forum, you'll have a much better chance of getting a response. Thanks and have fun.
Post Reply
Posts: 2
Joined: 28 Jul 2015 06:11
Product: Datacentre
Region: Singapore

Formatting text within formula in forms

Post by ytlimsg » 28 Jul 2015 06:16


I was wondering if, in designing a form, I might be able to format certain text within a field (for example in the Detail.Description column of a table in a form, I want to be able to write something like if(Detail.StockCode="1234", Detail.Description(boldtext), Detail.Description) => Where if the stockcode of the item is 1234, then I would like for the Detail Description to be bold, else it would just be normal text.

Is there such a functionality in Moneyworks? I can't seem to find it anywhere. The equivalent in MS Excel would be Conditional Formatting.

Still trying to get to grips with this software after many years on MYOB. Many thanks in advance!

Post Reply