remove paperclip icon and add a caption in a datasheet

[Paul]

I have a question:
I have àn attachment field in a table and I set a caption for it called
''certificate model". However, when I generate a form for that table and view
it in form view, the label still says ''certificate model". BUT when I view
the form as a datasheet, it shows me only a paperclip icon. I set the
caption's label to ''certificate model" yet it still shows me a paperclip
icon. Do you have any ideas so as to how should I solve this issue?

 

[Jeff Conrad [MSFT]]

Hi Paul,

Try this:
1. Open the datasheet form in Design view
2. Click the attachment field
3. Open the Property Sheet window
4. Set the property called Datasheet Caption to Certificate model (the
property is the fifth one down on the All tab)
5. Save and close your datasheet form
6. Reopen your form in Datasheet view and verify you see your changed
caption

--
Jeff Conrad - Access Junkie - MVP Alumnus
SDET II - Access Test Team - Microsoft Corporation

Co-author - Microsoft Office Access 2007 Inside Out
Presenter - Microsoft Access 2007 Essentials
http://www.accessmvp.com/JConrad/accessjunkie.html
Access 2007 Info: http://www.AccessJunkie.com

 

[Paul]

Hi I tried it and it did not work. The caption property is set to
"Certificate model" and in the Form View I can see the label as "Certificate
model" but when I switch to datasheet view, I just see a paperclip icon.
Since I have 2 attachment fields, this can be a problem because I cannot
label them, and any person using this database will not know which paperclip
belong to which field,,,,
Have you ever seen something like this ??

 

[Jeff Conrad [MSFT]]

Paul,

I was talking about the Datasheet Caption property for the attachment
control on the *form*, not the caption property of the field at the table
level nor the label control for the attachment on the form.

Your issue does not repro for me. Are you absolutely certain you are
clicking the attachment control on the datasheet form in Design View and
setting the property called "Datasheet Caption"?

--
Jeff Conrad - Access Junkie - MVP Alumnus
SDET II - Access Test Team - Microsoft Corporation

Co-author - Microsoft Office Access 2007 Inside Out
Presenter - Microsoft Access 2007 Essentials
http://www.accessmvp.com/JConrad/accessjunkie.html
Access 2007 Info: http://www.AccessJunkie.com

----------
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.mspx

 

[Paul]

Thanks Jeff,
Thats does solve my problem

I see that you also wrote a book on Access 2007. It seems that you are
expert ...

Maybe we will meet again in other forum.....

Thanks again,

Paul

 

[Jeff Conrad [MSFT]]

Great, glad you have it working now Paul.
Good luck with your project.

--
Jeff Conrad - Access Junkie - MVP Alumnus
SDET II - Access Test Team - Microsoft Corporation

Co-author - Microsoft Office Access 2007 Inside Out
Presenter - Microsoft Access 2007 Essentials
http://www.accessmvp.com/JConrad/accessjunkie.html
Access 2007 Info: http://www.AccessJunkie.com