Attachment Datatype

S

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.
 
D

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
 
S

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
 
K

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
 
Top