The UK's Number 1 for Microsoft Office Training

Sitemap

Bookmark page

Printable version

Course updates
due to adverse
weather conditions

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Access Training and help » '&' vs. '+' when you are concatenating

	98.3 % recommend us
	More live stats...

Bookmark this page

Share this with a friend or colleague:

The UK's most regular
instructor-led training courses.

Training information:

'&' vs. '+' when you are concatenating

Resolved · Low Priority · Version 2007

ReplyTue 28 Apr 2009, 16:51Delegate Mark said...

'&' vs. '+' when you are concatenating

When doing my training i used the '&' symbol to concatenate and it seems to work although the notes say to use '+'. I'm so used to using excel I'm sure I will lapse into using '&' and I want to know if this will cause any problems.

For upcoming training course dates see: Pricing & availability

ReplyWed 29 Apr 2009, 16:32Trainer Rajeev said...

RE: '&' vs. '+' when you are concatenating

Dear Mark

Thank you for attending Access Intermediate course!! I hope you enjoyed the course and benefited from it.

Please refer to the following link that explains the difference between the two:

http://www.blurtit.com/q641973.html

If you are using this generally in Access then it should not be much of a problem as they can be used Interchangeably
Please note that it is more specific to Visual Basic so if you plan to do VVBA in Access then it may cause some problems as it mentions in the article!

I hope this has answered your query.

If this has answered your query then I would request you to please mark the question as resolved!! If not and you have a specific question related to this then please post it as a new question and we should be able to provide you the solution for it!!

Kindest Regards

Rajeev Rawat
MOS Master Instructor 2000 and 2003
MCAS Master Instructor 2007
MCT

Access articles

· Do You Have Trouble Understanding Databases? Consider a One-on-One Access Course
· Microsoft Access Tighten your Security Controls
· Want To Find Out About Access Queries?
· How To Create Your Own Access 2007/2010 Navigation Pane
· Use Microsoft Access to manage your work/life balance

Please browse our web site to find out more about
2002 access online training and other Microsoft training courses.

Access tip:

Change The Default Font in Access 2003

You can change the default font in Access 2003 so that whenever you create a new database your preferred font is automatically set.

To change the default font:

1.From the menu bar select Tools.
2.Click Options.
3.Go to the Datasheet tab:
4.In the Default font section select your preferred font from the list of fonts e.g. Arial.
5.Select your preferred size from the size menu e.g. 12.
6.Click Apply.

Click on the Tables/queries tab:
1.In the Query Design font section select your preferred font from the list of fonts e.g. Arial.
2.Select your preferred size from the size menu e.g. 12.
3.Click Apply.
4.Click OK.

The default font for Access has now been changed.

View all Access hints and tips

How can I view all the information on a spreadsheet

» Forum post: Excel

Rate this page:

Currently 2.15/5
1
2
3
4
5

2.2/5 (213 votes cast)

Add to:

Follow @beststl on Twitter

© 2012 Best STL. All Rights Reserved. A Microsoft software training company. info
All prices offered for business users and exclude VAT. E&OE · Terms and Conditions