vbCrLf

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I use this code in an event on a button on one of my forms:
"testing" & vbCrLf & "testing" (and it works fine)

I'm tring to use it in a query. Here is how it looks:

aaa: [A] & vbCrLf &

Am I doing something wrong?
 
Hi,

VBA variables and constants are NOT accessible from Jet-SQL.

A & Chr$(13) & Chr$(10) & B


should do, since Chr$( ) is a function and vbCrLf is ëquivalent to
Chr$(13) & Chr$(10)




Hoping it may help,
Vanderghast, Access MVP
 
vbCRLF is an intrinsic constant that translates to an integer value, thus is
only useful in VBA Code.

Try:

aaa: [A] & CHR$(13) &
 
Back
Top