User Defined Fields (Hmmm!)

[SpiderByte]

I would like to add 6 generic fields to a form and let the user change the label caption as well as change the field format in the table ie one field may be text while another may be double interger while another may be changed to the date format. Is there a smart way to do this?

Thanks in advance

 

[Jack Cowley]

My question would be why would you want to do this, but that is neither here nor there.... Search Help for ALTER TABLE. You can do what you want with this method, but you will have to delete the field and recreate it if you want to change the Field Name.

hth,
Jack