Prev: No relation between tables anymore - stevie PIMPS again!
Next: Table field length limit alternative
From: laura on 15 Mar 2010 15:35
Things like on the forms (beside each label), how can i include a question
mark symbol that, when the mouse hovers over it, shows the format needed for
the data that should be input? e.g. contact number - 028 90 000000
From: Steve on 15 Mar 2010 16:50
You can easily do this with the Control Tip Text property. Open your form in
design view and select the control which you want to show the format for.
Open properties and go to the Other tab. Type in your example format in the
Control Tip Text property.

Steve
santus(a)penn.com


"laura" <laura(a)discussions.microsoft.com> wrote in message
news:573EE12F-B42C-4238-9AE3-A05311CE00AF(a)microsoft.com...
> Things like on the forms (beside each label), how can i include a question
> mark symbol that, when the mouse hovers over it, shows the format needed
> for
> the data that should be input? e.g. contact number - 028 90 000000


From: Jeff Boyce on 15 Mar 2010 17:08
Laura

Forcing your users to follow your formatting may leave them less likely to
use your application.

What about the idea of you adding validation code that reformats what they
enter into the "proper form"?

Regards

Jeff Boyce
Microsoft Access MVP

--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.


"laura" <laura(a)discussions.microsoft.com> wrote in message
news:573EE12F-B42C-4238-9AE3-A05311CE00AF(a)microsoft.com...
> Things like on the forms (beside each label), how can i include a question
> mark symbol that, when the mouse hovers over it, shows the format needed
> for
> the data that should be input? e.g. contact number - 028 90 000000


 | 
Pages: 1
Prev: No relation between tables anymore - stevie PIMPS again!
Next: Table field length limit alternative