I originally read an answer to this on EE but have looked for hours now and can't find it...sorry for the repeat!
I have a form which gives a conditional total (i.e. no of products a client ordered, once you choose a client). Before the client is selected the field shows #error - as expected. Someone posted some code which changed the font colour to white until a real value was shown - which worked nicely in forms and reports, if anyone can do this that would be peachy.