Changing colour of text

[Macaw]

Good morning. I have checked through the forums but could not find the answer. My client has an invoice form with the invoice number (as text) in the following format 1909/05/07/01

The 01 is the invoice number of the month: 1st, 2nd. 3rd etc. He would like that number (the last two digits) a different colour than the rest. I know in excel you have the range[].character ...... that you can use. I have tried different ways of doing this in VBA. Conditional formatting does not work. Any suggestions?

Regards,


Dmitri

[CJ_London]

you need to use richtext.

How you use it depends on how the invoice number is generated at the moment - is it stored as a complete value in a field, or calculated from the invoice date in the report?

[Macaw]

you need to use richtext.

How you use it depends on how the invoice number is generated at the moment - is it stored as a complete value in a field, or calculated from the invoice date in the report?

It is richtext and stored as a value that is entered each time

[June7]

So the value is saved into a memo Rich Text field but it is not actually formatted? Options:
1. save date and sequence number into separate fields and format each bound textbox
2. parse the parts into separate textboxes and format each textbox
3. expression in a single unbound textbox reconstructs string with HTML tags

[CJ_London]

when the number is created you need add the richtext code for font color - something like

invnum=left(invnum,len(invnum)-2) & "<font color=""#ED1C24"">" & right(invnum,2) & "</font>"

Using richtext on a key field like an invoice number is not a good idea - can play havoc with sorting/filtering/criteria. So probably safer to store the number has plaintext and use the above in your form/report recordsource

An alternative on your invoice report is to have two adjacent controls, one formatted black and populated the left chars, the other red and populated with the last two chars.

[Macaw]

Thanks folks. Much appreciated.

invnum=left(invnum,len(invnum)-2) & "<font color=""#ED1C24"">" & right(invnum,2) & "</font>" works like a charm.

Once again, thanks to all who took the time to respond <3