By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,039 Members | 1,831 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,039 IT Pros & Developers. It's quick & easy.

VBA Syntax error

P: 5
I'm new to programming and very unfamiliar with VBA - would welcome any advice on the following... When run in Access, the following code is highlighted as a syntax error. Grateful for any feedback! Many thanks.


strLocMessage = strLocMessage & vbCrLf & "Break Down of Order" & vbCrLf & _

" 2 - " & Me![2Coin] & vbCrLf & _
" 1 - " & Me![1Coin] & vbCrLf & _
" 50p - " & Me![50pcoin] & vbCrLf & _
" 20p - " & Me![20pcoin] & vbCrLf & _
" 10p - " & Me![10pcoin] & vbCrLf & _
" 5p - " & Me![5pcoin] & vbCrLf & _
" 2p - " & Me![2pcoin] & vbCrLf & _
" 1p - " & Me![1pcoin] & vbCrLf & _

"Total Amount " & Me![TotalValue] & vbCrLf & _
"Delivery Date " & Format(Me![DateReady], "dddd dd mmmm yyyy") & vbCrLf & vbCrLf & _
"Please arrange for this order to delivered to the store on the above date. " & vbCrLf
Sep 19 '07 #1
Share this question for a faster answer!
Share on Google+

Post your reply

Sign in to post your reply or Sign up for a free account.