Limiting text formatting abilities to all fields in database

[AspenArchive]

That's simply it - is there a way to deny text formatting to all fields within a database? Data ENTRY is allowed, just not formatting, it MUST stay the way the layout has described it.

I've set validation on some fields for size and font and color, but there are 100+ fields that need these options and not only would that be tedious work (though creating a database can certainly be so) it also does not allow me the option to deny alignment formatting, which is one of the most important ones - any suggestions?

I posted this again in the Accounts and Privileges forum, so apologies if it repeats...

Thanks!

SC

[Fenton]

It is pretty easy. In Define Fields, Options, Auto-enter by calculation, uncheck "Do not replace existing value", with the formula:

Evaluate ( Quote ( the field name here ) )

(P.S. I deleted your other post. There were no answers yet. It's not an Accounts and Privileges question; this is the best place for it.)

[Reed]

This is a cool trick... I didn't realize that evaluate would strip out all formatting