Re: On Change Bug?

The only reason that i will not use the code on the afterupdate event is that
I want the name in the caption to change as the user types the information
into the database, if I do it in the afterupdate event it will not make the
change until the record is complete or you add a new record. I did try the
code there first, it just didn't have the effect that I wanted and the whole
reason for doing this on this event is the effect, which is the changing of
the name as you go. I know it is probably not really a pressing and urgent
issue, but I think it is a cool effect and if it all possible I would like to
keep it...

The code right now is in the CurrentEvent of the form and on the OnChange
event of the fields that are used to change the caption.

Larry Linson wrote:
>The OnChange event fires for every keystroke of the Control. I really doubt
>that is the event to which you want to respond. I suspect you really want to
>change the caption only when you have all three, First/Middle/Last names
>entered. I am also not sure I can see a "business purpose" for changing the
>caption, unless you are likely to have multiple copies of the same form
>open, and some minimized. The caption isn't really a very convenient place
>to have changeable data.
>
>But, assuming there is a reason to change the caption, my suggestion would
>be to call the same procedure from the AfterUpdate event of each of the name
>fields, check that all three have been entered, and then execute the code
>you show. Assuming you'll be using the same or similar form to edit the
>records, put the code in the Current event, as well, so the caption will
>reflect the person whose data is being edited, as well.
>
> Larry Linson
> Microsoft Access MVP
>
>> Okay I have a form whose caption is based on some information on the form.
>> The information updates the caption at every change. For example the
>[quoted text clipped - 31 lines]
>>
>> Any help or suggestions would be appreciated.

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-forms/200512/1
.

Relevant Pages

  • Re: ShowMessage can have any title!
    ... I never use ShowMessage except for debugging, and one reason is the ... MessageBox function gives you control over the caption as well. ... ShowInfoMessage (similar to ShowMessage), ShowConfirmationMessage ...
    (comp.lang.pascal.delphi.misc)
  • Re: marginpar not in outer par mode
    ... \marginpar within the caption produces ... LaTeX Error: Not in outer par mode. ... I appreciate there is probably a good reason for that, but I still need to do that margin note. ...
    (comp.text.tex)
  • Re: marginpar not in outer par mode
    ... \marginpar within the caption produces ... LaTeX Error: Not in outer par mode. ... I appreciate there is probably a good reason for that, but I still need to do ...
    (comp.text.tex)
  • Overridden button caption - left-aligned???
    ... I have VFP8 code that overrides a button caption but the caption displays ... left-aligned rather than centered for some reason. ...
    (microsoft.public.fox.programmer.exchange)
  • Re: On Change Bug?
    ... One of those would be to display the information in large ... your users to the unfamiliar UI. ... > The only reason that i will not use the code on the afterupdate event is ... > event of the fields that are used to change the caption. ...
    (microsoft.public.access.forms)