Dynamic Datasheet Caption

[Jester0001]

I have a form with a datasheet. I can change the field names of the datasheet by changing the "Datasheet Caption" property on the property sheet. However, it seems that I can only have a static name for the field. Is there a way to have the Datasheet Caption be dynamic?

[Missinglinq]

In code it'd be

Me.YourControlName.Controls(0).Caption = "Whatever"

Just out of curiosity, why would you want to do something like this, dynamically?

Linq ;0)>

[Jester0001]

Using Access 2010, I was hoping to just try to set the Datasheet Caption in the Property Sheet window. I suppose I can resort to VBA if necessary.

As for "Why?", the datasheet is on a form used for inserting lab results for consecutive days. One test has multiple results. Ex. The results for Day 2, Day 3, etc. The field names are "Day2", "Day3", etc. I already have validation in place to make sure that the results can only be entered in the records on the correct day, but if the field name has the correct date, then this will aid the user in data entry.

Now I just need to figure out which control event I should use for the code.

I'll try it out and let you know if it works.

Thanks!

[Jester0001]

I got it to work per your suggestion. Thank you Missinglinq!

[Missinglinq]

Glad you got it working. You'll find that most anything you want to do dynamically has to be done through code or macros, with the most flexibility coming thru the use of code, not through the Property Pane.

I understand about tracking lab results, having been in health care for 40 years, but your explanation of what you're doing is somewhat confusing, and hints at your app not being Normalized properly. The 'columns' of a Datasheet, which are actually Fields, should be made up of the tests being run and their Dates;

TestDate CBC HGB Na+ K+, etc.

with the TestDate usually being the first Field in the Record, not things like

Day1, Day2, etc.

At any rate, good luck with your project!

Linq ;0)>