Formatting of disabled fields

[Remster]

This is a relatively minor issue, but a niggling one nonetheless. I've set some of the fields on my form to be disabled through conditional formatting. Some of my other fields are checkboxes, option groups and subforms, which can't be disabled through conditional formatting, so I've used VBA. However, the appearances of the labels for these fields differ depending on which method is used – see the attached sample. Is there any way of simulating one or the other method so that the labels look the same? (I realise I have the option of using only VBA, but that would mean undoing a decent amount of work!)

[Remster]

Right, I've been told the sunken text is hard to read, so I need the code for flattening sunken text (the second lable in my attached example). Surely someone has the answer!

[Remster]

I've hit upon the solution to this one, completely by chance. I shan't go into how, but here it is:

1. Change the Back Style of the label for the control that you've disabled using VBA from 'Transparent' to 'Normal'.
2. Create a duplicate of that label, position it in the same place as the original, and send it to the back.

If you've used the conditional formatting method and want to create the sunken text effect for the otherwise flat text, skip straight to step 2. I don't know why it works, but it does!