By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
432,046 Members | 2,105 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 432,046 IT Pros & Developers. It's quick & easy.

caption value problem in design view

P: n/a
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
Nov 13 '05 #1
Share this Question
Share on Google+
7 Replies


P: n/a
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.chello.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

Nov 13 '05 #2

P: n/a
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


Nov 13 '05 #3

P: n/a
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.com>
??????: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

Nov 13 '05 #4

P: n/a
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.com>
??????: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 wishthe >caption value to be "". What can I do?
>
>what is the form event from form view to design view?
>
>Thanks in advance,
>
>Paul
>


Nov 13 '05 #5

P: n/a
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.com>
??????: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.
Nov 13 '05 #6

P: n/a
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.

Nov 13 '05 #7

P: n/a
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.
Nov 13 '05 #8

This discussion thread is closed

Replies have been disabled for this discussion.