>Can I create a SubClass of CA and create a generic COnversionFunc that loop through the afields() and rtrims all the character fields?
Sure. I do that in my builder once per table. I am not sure I want that code firing every time a CA is instanciated during runtime. Once you have the ConversionFunc list, I see no need to include an afields loop in the actual CA that runs every time the CA is "opened". If the table structure changes where varchar field is added or removed, it is a fairly simple matter to tweek the existing property to reflect the change.
>Also, if I rtrim a character field isn't it stored right back into the character field in the view and then padded again?
Yes, but the RTRIM is only needed/used when the data is sent back to the server so you do not have RPADded spaces in VARCHAR fields. <s>
Mark McCasland
Midlothian, TX USA