remove paperclip icon and add a caption in a datasheet

  • Thread starter Thread starter Paul
  • Start date Start date
P

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?
 
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
 
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 ??
 
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
 
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
 
Back
Top