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.

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
--
Don''t forget to rate the post if it was helpful!

email address is invalid
Please reply to newsgroup only.



"Sunny Liu" wrote:

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

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

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

"Sunny Liu" wrote in message:
news:AB8F0DE5-00EF-4A9B-AE5B-(E-Mail Removed)...

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

Hi Dale,

Thanks millions! This solves the problem.

Sunny

"Dale Fye" wrote:

> 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
> --
> Don''t forget to rate the post if it was helpful!
>
> email address is invalid
> Please reply to newsgroup only.
>
>
>
> "Sunny Liu" wrote:
>
> > 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.

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]" wrote:

> 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
>
> ----------
> 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
> ----------
>
> "Sunny Liu" wrote in message:
> news:AB8F0DE5-00EF-4A9B-AE5B-(E-Mail Removed)...
>
> > 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?
>
>
>

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

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

"Sunny Liu" wrote in message:
news:A0C55F06-241D-4A98-AD2C-(E-Mail Removed)...

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

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

"Jeff Conrad [MSFT]" wrote:

> 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
>
> ----------
> 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
> ----------
>
> "Sunny Liu" wrote in message:
> news:A0C55F06-241D-4A98-AD2C-(E-Mail Removed)...
>
> > 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.
>
>
>