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
307 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
4 Comments
 
LVL 61

Accepted Solution

by:
mbizup earned 500 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

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

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

Describes a method of obtaining an object variable to an already running instance of Microsoft Access so that it can be controlled via automation.
In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
Familiarize people with the process of utilizing SQL Server stored procedures from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Micr…
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.

726 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