Programmatically change Textbx/ComboBx/CheckBx Name in Datasheet V

S

slickdock

I hope this makes sense:

I allow users to set their own field names through a form called
frmCustomFieldLabels, with recordsource t_CustomFieldLabels. It contains
fields named F1, F2, F3 (field1, field2, field3).
The users enter whatever field names they want. Some will eventually end up
as labels to text box fields, Check box fields, and some to Combo Boxes.

After filling out these field labels, the form stays open and
frmQuestionairre opens. Its record source is t_Questionairre. I have
changed each field label in frmQuestionairre to be a textbox, and I set the
default values of each "textbox label" as follows: the default value of
Field1Label becomes [forms]![frmCustomFieldLabels]![Field1], the default
value of Field2Label becomes [forms]![frmCustomFieldLabels]![Field2], etc.

This works great and allows users to define their own field names in my
runtime database application.

Problem: DATASHEET VIEW...When they switch frmQuestionairre to Datasheet
view, how can I make the column heading of each ControlBox take on the value
of each CustomFieldLabel?

Thanks so much.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top