Re: Clearing the captions of labels

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

From: Evan McCutchen (evanspamsucks_at_radiologyonesource.com)
Date: 11/02/04


Date: Tue, 2 Nov 2004 16:54:05 -0600

thanks!
"fredg" <fgutkind@example.invalid> wrote in message
news:xk1xzo9btslv$.1ez67z3ggtiy8.dlg@40tude.net...
> On Tue, 2 Nov 2004 16:03:53 -0600, Evan McCutchen wrote:
>
>> Hello,
>>
>> When a viewing form has reached the end of a set of records (ie, the form
>> displays "(Autonumber)" in the numbering field, how can i clear the
>> captions
>> of labels on the form?
>>
>> Any help would be greatly appreciated!
>>
>> Thanks,
>> E.A. McCutchen
>> evan AT radiologyonesource DOT com
>
> Well, this is what you asked for.
> The only problem you are going to run into is that once you clear the
> captions, there gone (in this Form session only) unless you have some
> way to put them back if you want them again. It's not a big deal to
> do, but you need to be aware of it. The next time you open the form,
> the labels are back anyway.
>
> Code the Form's Current event:
> If Me.NewRecord = True Then
> Dim c As Control
> 'just clear the detail section unless you want everything, then use
> For each c in Controls instead
> For Each c In Me.Section(0).Controls
> If TypeOf c Is Label Then
> c.Caption = ""
> End If
> Next c
> End If
>
>
> --
> Fred
> Please only reply to this newsgroup.
> I do not reply to personal email.



Relevant Pages

  • Re: Changeable form labels
    ... This code goes into the Form_Load event of the form that contains the labels ... whose captions you want to set. ... matches the name of the control on your form. ... For Each ctl In Me.Detail.Controls ...
    (microsoft.public.access.forms)
  • Re: Captions and references for Tables and Figures
    ... rid of those labels hoping that it would solve the problem, ... caption,Wordchanges all of the captions of the ... losing the cross reference fields. ... caption label and number, press OK, and then control V the text into ...
    (microsoft.public.word.docmanagement)
  • Re: Clearing the captions of labels
    ... > When a viewing form has reached the end of a set of records (ie, ... captions, there gone (in this Form session only) unless you have some ... the labels are back anyway. ...
    (microsoft.public.access.formscoding)
  • Re: WinCreateStdWindow, Client and Frame question
    ... Rearranged order of frame window destruction so it can ... Labels: v2.1.11.13 ... When focussing a control, ... partly to fix the issue that after re-invoking a dialog, ...
    (comp.os.os2.programmer.misc)
  • Re: Printing Labels but designating which label on sheet to start
    ... it shows the number I entered in the report header. ... I have a report set up that is perfect for a full sheet of labels. ... Leave it's control source blank. ...
    (microsoft.public.access.reports)