I think I should have stated 'I know that the database fields have a format area where I can put a !', but like I stated, this does not work for ensuring that the data istored correctly.


>You're on the right track. Just continue that thought into the database container. Open the database, modify the table, set the field property (format: !)
>
>
>>I was wondering if the database can be defined so that when a field is set up it automatically ensures that the field data is uppercased when stored. I would like the database to ensure some things happen when new data is entered into the tables. One thing is just to ensure that all UserNames are entered as uppercase. So I think that the Database can have some responsibility for ensuring this to happen, instead of a business rule or the presentation tier. I know that the fields have a format area where I can put a !, but this only displays the information as uppercase, it does not ensure that the data is stored in uppercase.
>>
>>Any suggestions please..