Re: On Change Bug?

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

As was pointed out more politely by others -- however "cool" you may think
the effect, changing the caption of the form is, at best, an "unusual and
unfamiliar" interface feature -- there are other, simpler,
less-disturbing-to-the-user approaches to showing what record is being
edited. One of those would be to display the information in large
characaters in the Form's Header... the information could be displayed in a
Label or a Text Box.

Please note that I suggested the AfterUpdate event of the Control into which
you are typing, not the Form's AfterUpdate, if you feel compelled to submit
your users to the unfamiliar UI. The Record is not, at least not
necessarily, saved before the Control's AfterUpdate.

Just for the record: my clients always wanted to insulate their users from
"unusual and unfamiliar" interface features, because they had to figure out
what was going on, and it caused a negative impact to their employees'
productivity.

Larry Linson
Microsoft Access MVP


"Ivan R via AccessMonster.com" <u6255@uwe> wrote in message
news:599c90a743764@xxxxxx
> 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: On Change Bug?
    ... the form header, you are right that is a good spot to put important ... 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 ...
    (microsoft.public.access.forms)
  • Re: MDI Form Question
    ... And I'm still pretty weak on the API calls. ... ....as for the Caption being blank... ... One for the main display of db info and a second for the forms needed ... Private Const SW_MAXIMIZE = 3 ...
    (microsoft.public.vb.general.discussion)
  • Re: Fields wont lock.
    ... The caption numbers ... To convert autonumbering (paragraph/outline numbering and LISTNUM ... display the Visual Basic Editor. ... also clear it from the style definitions. ...
    (microsoft.public.word.numbering)
  • Re: showing larger images in pop up window.
    ... > display a pop up window with larger image and caption when activated. ... Download times do MATTER. ...
    (alt.html)
  • Re: Freeview Radio Captions
    ... caption that displayed on the radio channel. ... that the updates to this onscreen display do not appear. ... Live Sport |", which is a caption that does not appear on the TVs with STBs, ... There will be an advert under the picture. ...
    (uk.tech.digital-tv)