Jul 7 2009, 09:39 AM
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).
Jul 7 2009, 09:42 AM
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.
Jul 7 2009, 09:45 AM
Good idea. This is setup as FE/BE (field/master). I'll set the BE as only form to modify.