Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

Access form - show "description of control" in control (i.e. when no room for a header on form)

Posted on 2014-04-01
4
Medium Priority
?
311 Views
Last Modified: 2014-04-09
Hi,

I have a very full access form with no space for headings.

Somebody on EE helped me with this a few years ago but I can't find the solution now!

I want to put a value in a control that tells the user what the control is.

E.g. I want to show <Make of Car> in a control before the user keys in the "make of car".  Note that this is NOT a default value , it is a description of what the control holds.

I think the previous solution (which I can't find) had a value in the FORMAT of the control ...
something like : @; <Make of Car>
0
Comment
Question by:Patrick O'Dea
  • 2
4 Comments
 
LVL 61

Accepted Solution

by:
mbizup earned 2000 total points
ID: 39968839
You're close!

You just need to enclose the desired text in quotes:


@;"< Make of Car>"
0
 

Author Closing Comment

by:Patrick O'Dea
ID: 39990209
Thanks once again!
0
 
LVL 61

Expert Comment

by:mbizup
ID: 39990382
You're very welcome!

I knew this question was familiar - I found your earlier question (where I learned that neat little trick from mx):

http://www.experts-exchange.com/Database/MS_Access/Q_27927389.html
0
 
LVL 75
ID: 39990640
And I learned it from Gustav Brock :-)
mx
0

Featured Post

Receive 1:1 tech help

Solve your biggest tech problems alongside global tech experts with 1:1 help.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Microsoft Access has a limit of 255 columns in a single table; SQL Server allows tables with over 255 columns, but reading that data is not necessarily simple.  The final solution for this task involved creating a custom text parser and then reading…
Explore the ways to Unlock VBA Project Password Excel 2010 & 2013 documents. Go through the article and perform the steps carefully to remove VBA Excel .xls file.
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …
Suggested Courses

577 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question