Prompt for alternate field name

[Lori]

I have a field that is being used for two possible values, bond or
contingency. If its being used for bond, I'd like the field name to read Bond
and contingency when its being used for contingency, is this possible?

 

[Brendan Reynolds]

If you just want to ask the user, sure, you can do that in the Open event of
the report ...

Private Sub Report_Open(Cancel As Integer)

Me.OrdersShippedLabel.Caption = InputBox$("Caption?")

End Sub

If you want to determine programmatically what the field is being used for,
I'd need more information as to how that can be logically determined.

 

[Lori]

perfect that was exactly what I was looking for.