Insert Comment in a Form?

  • Thread starter Thread starter Greta
  • Start date Start date
G

Greta

Is there a way to insert a comment, like you can in Excel,
in an Access form?
Each of my fields in the form I'm building will either be
a date or "failed"...if it's "failed" then I need a
comment box for data-entry to tell why it failed.
If it's a date, it's just the date and we assume the test
was successful.
I'm running Access 2002.
Thanks,
Greta
 
Greta,
Just add a label to the form.
Make it not visible.
Code each control's Before Update event:

If Me![ControlName] = "whatever" Then
Labelname.Caption = "Your comments here"
LabelName.Visible = True
Else
LabelName.Visible = false
End If

You can use the same label for all the controls.
Just change the caption as needed.
 
No matter what you do, you are going to have at least 196 different comments
if each control gets it's own wording.
If you want the label to appear in a certain position alongside a text
control, just move it using code when you make it visible.

Comment type boxes, as such, are not available in Access.

Besides my previous solution, perhaps you can use the control's control tip
text property.
Set each control's basic control tip text in Form Design View.
Then the actual control tip text can be changed, if needed, using VBA.
Me.[ControlName].ControlTipText = "Something else"
Unfortunately, the mouse must hover over the control for this to be seen,
and you still need to set the tip for 196 different fields if each one is
different.
--
Fred

Please reply only to this newsgroup.
I do not reply to personal e-mail.


Greta said:
Hi, Fred...
That's close, but it isn't quite what I need. I've got
196 fields, what I need is a pop-up-type text box that can
be viewed or hidden...for each of the fields. In Excel
you can insert a comment that can be opened or
closed...I'm hoping there's something similar in Access.
Thanks for you help!
Greta

-----Original Message-----
Greta,
Just add a label to the form.
Make it not visible.
Code each control's Before Update event:

If Me![ControlName] = "whatever" Then
Labelname.Caption = "Your comments here"
LabelName.Visible = True
Else
LabelName.Visible = false
End If

You can use the same label for all the controls.
Just change the caption as needed.

--
Fred

Please reply only to this newsgroup.
I do not reply to personal e-mail.


Greta said:
Is there a way to insert a comment, like you can in Excel,
in an Access form?
Each of my fields in the form I'm building will either be
a date or "failed"...if it's "failed" then I need a
comment box for data-entry to tell why it failed.
If it's a date, it's just the date and we assume the test
was successful.
I'm running Access 2002.
Thanks,
Greta
Click to expand...


.
Click to expand...
Click to expand...
 
Yeah, I guess I'm in for it.
Thanks so much for your help...I think that the control is
going to work.
Greta
-----Original Message-----
No matter what you do, you are going to have at least 196 different comments
if each control gets it's own wording.
If you want the label to appear in a certain position alongside a text
control, just move it using code when you make it visible.

Comment type boxes, as such, are not available in Access.

Besides my previous solution, perhaps you can use the control's control tip
text property.
Set each control's basic control tip text in Form Design View.
Then the actual control tip text can be changed, if needed, using VBA.
Me.[ControlName].ControlTipText = "Something else"
Unfortunately, the mouse must hover over the control for this to be seen,
and you still need to set the tip for 196 different fields if each one is
different.
--
Fred

Please reply only to this newsgroup.
I do not reply to personal e-mail.


Greta said:
Hi, Fred...
That's close, but it isn't quite what I need. I've got
196 fields, what I need is a pop-up-type text box that can
be viewed or hidden...for each of the fields. In Excel
you can insert a comment that can be opened or
closed...I'm hoping there's something similar in Access.
Thanks for you help!
Greta

-----Original Message-----
Greta,
Just add a label to the form.
Make it not visible.
Code each control's Before Update event:

If Me![ControlName] = "whatever" Then
Labelname.Caption = "Your comments here"
LabelName.Visible = True
Else
LabelName.Visible = false
End If

You can use the same label for all the controls.
Just change the caption as needed.

--
Fred

Please reply only to this newsgroup.
I do not reply to personal e-mail.


Is there a way to insert a comment, like you can in Excel,
in an Access form?
Each of my fields in the form I'm building will
Click to expand...
either
be
a date or "failed"...if it's "failed" then I need a
comment box for data-entry to tell why it failed.
If it's a date, it's just the date and we assume the test
was successful.
I'm running Access 2002.
Thanks,
Greta


.
Click to expand...
Click to expand...


.
Click to expand...
 
Greta,

I understand what you want to do. Unfortunately, there is
no easy way to do this.

What you can do is create a comments table. This table
will have at least 4 fields. The first will be the table
name that the record exists in. The second (and possibly
more) field will be the primary key of the record.
Thirdly, add a field for the field name that has a comment
added. The last field will have the comment itself.
Possibly add a user name and date, especially if you want
multiple comments for each field.

You will have to code this so that the comment form knows
where to put the data.

Chris

-----Original Message-----
Yeah, I guess I'm in for it.
Thanks so much for your help...I think that the control is
going to work.
Greta
-----Original Message-----
No matter what you do, you are going to have at least
Click to expand...
196
different comments
if each control gets it's own wording.
If you want the label to appear in a certain position alongside a text
control, just move it using code when you make it visible.

Comment type boxes, as such, are not available in Access.

Besides my previous solution, perhaps you can use the control's control tip
text property.
Set each control's basic control tip text in Form Design View.
Then the actual control tip text can be changed, if needed, using VBA.
Me.[ControlName].ControlTipText = "Something else"
Unfortunately, the mouse must hover over the control for this to be seen,
and you still need to set the tip for 196 different fields if each one is
different.
--
Fred

Please reply only to this newsgroup.
I do not reply to personal e-mail.


Greta said:
Hi, Fred...
That's close, but it isn't quite what I need. I've got
196 fields, what I need is a pop-up-type text box that can
be viewed or hidden...for each of the fields. In Excel
you can insert a comment that can be opened or
closed...I'm hoping there's something similar in Access.
Thanks for you help!
Greta


-----Original Message-----
Greta,
Just add a label to the form.
Make it not visible.
Code each control's Before Update event:

If Me![ControlName] = "whatever" Then
Labelname.Caption = "Your comments here"
LabelName.Visible = True
Else
LabelName.Visible = false
End If

You can use the same label for all the controls.
Just change the caption as needed.

--
Fred

Please reply only to this newsgroup.
I do not reply to personal e-mail.


Is there a way to insert a comment, like you can in
Excel,
in an Access form?
Each of my fields in the form I'm building will either
be
a date or "failed"...if it's "failed" then I need a
comment box for data-entry to tell why it failed.
If it's a date, it's just the date and we assume the
test
was successful.
I'm running Access 2002.
Thanks,
Greta


.
Click to expand...


.
Click to expand...
.
Click to expand...
 
Back
Top