Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Can I use an alias on form datasheet view?

Status
Not open for further replies.

TheresAlwaysAWay

Programmer
Mar 15, 2016
145
US
I have several places I'd like to use this, but here's one example.

I have a processor name form that lists employees who are processors. Within that group are several levels that are denoted by checkboxes and later programming that allows them to do (or not do) certain things. On the form view itself I have a long descriptive name so that the admin staff understands exactly what the box is for. An example is "Assign user to receive Waiting CS notifications". I need that level of clarity, but when switching to the datasheet view I have this horribly long name for a tiny checkbox which takes up a ton of room on the screen because I have to make the field wide enough to read it to know what it is. If I narrow the field down the field display name is just a couple of characters, like "Ass" in this example.

Ideally what I'd like to do for this example is to simply have a short alias like "CS" in the datasheet view so the displayed field can be of reasonable width and be understandable by staff as to what it represents, while maintaining the full description in form view.

Is there any way to create an alias that only displays in datasheet view?

As always, thank you in advance.
 
Never mind. I figured out how to do it.

First, I disassociated the label from the control. Then I created a label field which sits right next to the checkbox but is not associated with it. That provides the admin staff with the descriptive name I want.

Then I associated a label with the control and changed its name to the short description I wanted. Finally, I made that label invisible. When it's all done I have exactly what I want...a long, descriptive label on the form view, and an abbreviated caption on the datasheet view!

Sorry to trouble you all.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top