Re: A HELP BOX

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

I'm not sure what you are saying. Are you saying that when I would enter the
textbox a label box would show up that would display the correct format and
then when I would leave the text box the labelbox would turn invisible?



"Jay Freedman" wrote:

The simplest solution for a userform is to put the instructions into a label
directly on the userform surface. If you want to get fancy, the _Exit()
procedure of the text box could set the label's .Visible property to False when
the user leaves the box; and it could also validate the user's entry and set the
Cancel argument to False so they can't exit until the format is correct.

On Fri, 12 Sep 2008 14:41:00 -0700, LEU <LEU@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:

It's a userform. Document control wants it that way for appearance.

LEU


"Jay Freedman" wrote:

On Fri, 12 Sep 2008 12:35:01 -0700, LEU <LEU@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:

I have a form that opens from a document. When you go to enter your name, it
needs to be in a set format. Is there a way that when I’m in the name textbox
a help or information balloon opens with the following : “Enter your First
name, CtrlTab twice, your Middle Initial, CtrlTab once, Last Name” and then
closes when they go to the next box?

What kind of "form" are we talking about here? A protected document, containing
form fields? An unprotected document containing a table (guessing because of the
CtrlTab)? A userform? The answer is different for each of these.

Also, it may be possible to avoid the need for an instruction popup by designing
the form properly. What "properly" means depends on how you're going to use the
completed document -- why do you need this specific format?


--
Regards,
Jay Freedman
Microsoft Word MVP FAQ: http://word.mvps.org
Email cannot be acknowledged; please post all follow-ups to the newsgroup so all may benefit.


.

Relevant Pages

  • Re: Questions about formating....
    ... I missed what you were saying. ... Everything in a textbox is text. ... > you places the same format as used in the cell in the textbox. ...
    (microsoft.public.excel.programming)
  • Re: Use TextBox Text As Function Name!
    ... the text in the TextBox changes to "<the name of the ... > OptionButton that was checked just before the selection change>2<the ... You have some design issues here. ... using the most common format. ...
    (microsoft.public.vb.general.discussion)
  • Re: Newbie question on formatting a field in table design
    ... Each department field is set to the default format ... multiplies the number entered by 100 and adds the "%" sign. ... right of the textbox, then store the number that way and do the ... normalized table design would convert your 11 ...
    (comp.databases.ms-access)
  • Re: Custom Cell Format problem
    ... I am having trouble with this "raw" TextBox. ... when I paste the contents of the UserForm into a new row on the sheet ... I have raw data in the format of 3 numbers, ...
    (microsoft.public.excel.programming)
  • Re: unicode textbox problem
    ... I get the data in the above format from SQL server. ... If I move the same data into an asp:textbox, or an html input textbox, I ... But I need this to show the Chinese characters. ...
    (microsoft.public.dotnet.languages.csharp)