caption value problem in design view

[Paul T. Rong]

Hello,

Often when I open one form, and (without closing it) open the form in its
design view, then all the caption value of the controls in this form
remained there in form's design view that is what I don't want. I wish the
caption value to be "". What can I do?

what is the form event from form view to design view?

Thanks in advance,

Paul

[Paul T. Rong]

PS: I used " Do Until rst.EOF ...loop" in the form's codes.

Is this the problem?

Paul

"Paul T. Rong" <et***@hotmail. com> дÈëÏûÏ¢ÐÂÎÅ
:DM************ ******@news.che llo.at...

Hello,

Often when I open one form, and (without closing it) open the form in its
design view, then all the caption value of the controls in this form
remained there in form's design view that is what I don't want. I wish the
caption value to be "". What can I do?

what is the form event from form view to design view?

Thanks in advance,

Paul

[Patrick Fisher]

If your question is "How do I set the Forms Caption" the answer is to
go to the Forms Properties, select All, go to Caption and enter your
Caption, if you do not want a caption simply enter a space.
Patrick

On Tue, 19 Oct 2004 07:56:19 GMT, "Paul T. Rong" <et***@hotmail. com>
wrote:

Hello,

Often when I open one form, and (without closing it) open the form in its
design view, then all the caption value of the controls in this form
remained there in form's design view that is what I don't want. I wish the
caption value to be "". What can I do?

what is the form event from form view to design view?

Thanks in advance,

Paul

[Paul T. Rong]

I didn't make myself understood. Ok, simply, I wish the caption value of all
labels of the form (which is actually a sub form) to be "", i.e, nothing
when it goes from the form view to design view or when it is closed. Is it
possible? What should I do?

Thanks,

Paul

"Patrick Fisher" <in**@psoftuk.c om>
??????:sr****** *************** ***********@4ax .com...

If your question is "How do I set the Forms Caption" the answer is to
go to the Forms Properties, select All, go to Caption and enter your
Caption, if you do not want a caption simply enter a space.
Patrick

On Tue, 19 Oct 2004 07:56:19 GMT, "Paul T. Rong" <et***@hotmail. com>
wrote:

Hello,

Often when I open one form, and (without closing it) open the form in its
design view, then all the caption value of the controls in this form
remained there in form's design view that is what I don't want. I wish thecaption value to be "". What can I do?

what is the form event from form view to design view?

Thanks in advance,

Paul

[Patrick Fisher]

It might make easier if you can explain why you need to do this, your
user will not see it in design mode.
Patrickl

On Tue, 19 Oct 2004 11:07:30 GMT, "Paul T. Rong" <et***@hotmail. com>
wrote:

I didn't make myself understood. Ok, simply, I wish the caption value of all
labels of the form (which is actually a sub form) to be "", i.e, nothing
when it goes from the form view to design view or when it is closed. Is it
possible? What should I do?

Thanks,

Paul

"Patrick Fisher" <in**@psoftuk.c om>
??????:sr***** *************** ************@4a x.com...

If your question is "How do I set the Forms Caption" the answer is to
go to the Forms Properties, select All, go to Caption and enter your
Caption, if you do not want a caption simply enter a space.
Patrick

On Tue, 19 Oct 2004 07:56:19 GMT, "Paul T. Rong" <et***@hotmail. com>
wrote:

>Hello,
>
>Often when I open one form, and (without closing it) open the form in its
>design view, then all the caption value of the controls in this form
>remained there in form's design view that is what I don't want. I wishthe >caption value to be "". What can I do?
>
>what is the form event from form view to design view?
>
>Thanks in advance,
>
>Paul
>

[fredg]

On Tue, 19 Oct 2004 11:07:30 GMT, Paul T. Rong wrote:

I didn't make myself understood. Ok, simply, I wish the caption value of all
labels of the form (which is actually a sub form) to be "", i.e, nothing
when it goes from the form view to design view or when it is closed. Is it
possible? What should I do?

Thanks,

Paul

"Patrick Fisher" <in**@psoftuk.c om>
??????:sr****** *************** ***********@4ax .com...

If your question is "How do I set the Forms Caption" the answer is to
go to the Forms Properties, select All, go to Caption and enter your
Caption, if you do not want a caption simply enter a space.
Patrick

On Tue, 19 Oct 2004 07:56:19 GMT, "Paul T. Rong" <et***@hotmail. com>
wrote:

Hello,

Often when I open one form, and (without closing it) open the form in its
design view, then all the caption value of the controls in this form
remained there in form's design view that is what I don't want. I wish thecaption value to be "". What can I do?

what is the form event from form view to design view?

Thanks in advance,

Paul

To change a label's caption to "" upon exiting a form, and having it
remain "" when opening the form the next time, it MUST be changed
while in design view.

You can do this using code:

DoCmd.OpenForm "YourForm", acDesign
Dim c As Control
For Each c In Forms!YourForm. Controls
If TypeOf c Is Label Then
c.Caption = ""
End If
Next c
DoCmd.Close acForm, "YourForm", acSaveYes

All the captions will be blank when the form is next opened.

--
Fred
Please only reply to this newsgroup.
I do not reply to personal email.

[Paul T. Rong]

Fred,

Thank you! But two questions:

1. "...it MUST be changed while in design view.", I didn't get you, what is
"it"? because I don't understand the it clause that I have problem to
understand the whole sentence.

2. the codes seem perfect and simple, but where, in which event, shall I put
the codes?

Paul

To change a label's caption to "" upon exiting a form, and having it
remain "" when opening the form the next time, it MUST be changed
while in design view.

You can do this using code:

DoCmd.OpenForm "YourForm", acDesign
Dim c As Control
For Each c In Forms!YourForm. Controls
If TypeOf c Is Label Then
c.Caption = ""
End If
Next c
DoCmd.Close acForm, "YourForm", acSaveYes

All the captions will be blank when the form is next opened.

--
Fred
Please only reply to this newsgroup.
I do not reply to personal email.

[fredg]

On Wed, 20 Oct 2004 07:13:21 GMT, Paul T. Rong wrote:

Fred,

Thank you! But two questions:

1. "...it MUST be changed while in design view.", I didn't get you, what is
"it"? because I don't understand the it clause that I have problem to
understand the whole sentence.
From a previous post of yours: Ok, simply, I wish the caption value of all
labels of the form (which is actually a sub form) to be "", i.e, nothing
when it goes from the form view to design view or when it is closed. <
The "it" refers to changing the label captions to blank, which is what
you previously stated you wish to do.

2. the codes seem perfect and simple, but where, in which event, shall I put
the codes?
Place it in the click event of a command button.
Paul

To change a label's caption to "" upon exiting a form, and having it
remain "" when opening the form the next time, it MUST be changed
while in design view.

You can do this using code:

DoCmd.OpenForm "YourForm", acDesign
Dim c As Control
For Each c In Forms!YourForm. Controls
If TypeOf c Is Label Then
c.Caption = ""
End If
Next c
DoCmd.Close acForm, "YourForm", acSaveYes

All the captions will be blank when the form is next opened.

--
Fred
Please only reply to this newsgroup.
I do not reply to personal email.

--
Fred
Please only reply to this newsgroup.
I do not reply to personal email.