Hello,
Is there a way to format a text box on a form to read out case sensitively based on the case noted in the fields validation rule? I have a field (TERM) with three options – Weekly, Bi-Weekly, and Monthly. I realize I can set it to CAPS, but would like the format to remain as noted in the validation (i.e., Bi-Weekly not BI-WEEKLY or bi-weekly).

Thanks,
SKK

Your better bet here would be to develop a form that allows enter/edit of data into the table of interest. On this form place a combo box that contains the choices in the way you would like them spelled.

Good idea. This is setup as FE/BE (field/master). I'll set the BE as only form to modify.

Thanks again,
SKK