Recent content by SpiderByte

I am trying to retrieve the attributes of a field eg data type, caption, length etc using vba code. Also can the attributes be changed, in particular the caption as well as the attributes. I would think using ALTER Table would be the go?

Is it possible to alternate 2 colors as the background color for all the records on a continuous form? eg first record has a grey background then the next has a white background and so on.

I would like to add a label to a continuous form BUT only be visible adjacent to the first record, ie one instance of the label and not all the other records, as it becomes repetitive to view the same label caption alongside each record. I would appreciate any suggestions you may have. Regards

I would like to have 6 generic bound fields on a form with labels. What is the smartest way to allow the user to change the label caption and the format of the field bound thru the textbox ie I may have set up the field as text format but the user would like to make it a double integer field...

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