If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
remove paperclip icon and add a caption in a datasheet
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? |
#2
|
|||
|
|||
remove paperclip icon and add a caption in a datasheet
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 ---------- 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" wrote in message news: ... 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? |
#3
|
|||
|
|||
remove paperclip icon and add a caption in a datasheet
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]" wrote: 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 ---------- 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" wrote in message news: ... 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? . |
#5
|
|||
|
|||
remove paperclip icon and add a caption in a datasheet
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]" wrote: 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" wrote in message news: ... 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]" wrote: 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 ---------- 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" wrote in message news: ... 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? . . |
#6
|
|||
|
|||
remove paperclip icon and add a caption in a datasheet
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 ---------- 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" wrote in message news: ... 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 |
Thread Tools | |
Display Modes | |
|
|