Attachment Datatype

[Sunny Liu]

i'm using Access 2007. I cannot find the Attachment data type in table design
mode. Can you tell me why?

Also I have another question.

In form design mode, I want to create a label control. After I type 'F&AD"
as the caption property, it displays as "FAD" in form view. It seesm Access
does not accept the "&" sign. Can you help explain why?

thanks in advance.

 

[Dale Fye]

Not familiar with 2007 (don't even know what an "attachment" datatype is).

However, in answer to your second question, the ampersand (&) is a character
Access uses to concatenate text strings. In order for it to show up in a
label, you will need to put two of these symbols together: F&&AD

HTH
Dale

 

[Jeff Conrad [MSFT]]

A brand new page just for you Sunny:
http://accessjunkie.com/faq_51.aspx

--
Jeff Conrad - Access Junkie - MVP Alumni
SDET - XAS Services - 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

 

[Sunny Liu]

Hi Dale,

Thanks millions! This solves the problem.

Sunny

 

[Sunny Liu]

Hi Jeff,

Thanks so much. Also, I find this website contain many other FAQ about
Access 2007 which is very useful to me. Thanks for sharing it with me.

Thanks,
Sunny

 

[Jeff Conrad [MSFT]]

You're welcome Sunny, I'm pleased to see you found my site helpful.

Good luck with your project.

--
Jeff Conrad - Access Junkie - MVP Alumni
SDET - XAS Services - 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

 

[ken]

How do you convert from MDA to ACCDB? and will 2003 version be able to open
and run this? if not what is the other best way to have word attachments on
my form
thanks
ken