Custom Captions

[fdcusa]

Can someone point me to a good reference for creating a Custom Captions
defaults table and referring to that table to display custom labels if
different than the default?

I'm thinking of a table like:

CapID, Name of Label
CapDefShort, Default Short Caption
CapCusShort, Custom Short Caption
CapDefLong, Default Long Caption
CapCusLong, Custom Long Caption

 

[fredg]

Can someone point me to a good reference for creating a Custom Captions
defaults table and referring to that table to display custom labels if
different than the default?

I'm thinking of a table like:

CapID, Name of Label
CapDefShort, Default Short Caption
CapCusShort, Custom Short Caption
CapDefLong, Default Long Caption
CapCusLong, Custom Long Caption

You haven't told us when you wish to get a different caption or which
caption to get under what circumstance.

Use something like this:
[LabelName].Caption = DLookUp("[CapCusLong]","tblCaptions","[CapID] =
some number value")

The above assumes that [CapID] is a number datatype.

You'll need to have some method to determine which caption to use.

 

[fdcusa]

Thanks for the reply!

The plan is to load CapCusShort OnLoad of a form (or Long for a report) to a
label as you have demonstrated. CapID is text, and is the name of the label
control. Earlier today I have experimented with DLookup which is the answer,
but is slow. I have come across Allen Browne's ELookup function which states
is faster, and will use it.

I thought it would be a nice touch, for example, where A calls a project
'Project', but B calls it a 'Task', then C wants it to be 'Job'. Less code
mods for customizing.