This topic is locked

Display Field - Custom Expressions

4/6/2006 12:29:54 PM
ASPRunnerPro General questions
N
npala2001 author

When using the Custom Expression feature with a Access database it doesn't seem to work. Am I writing the expression correctly.
AuditID+' '+Division+' '+AuditYear

Sergey Kornilov admin 4/6/2006

Probably you need to convert numeric values to strings before concatenation.

Try this:

CStr(AuditID)+' '+CStr(Division)+' '+CStr(AuditYear)
P
peter van mechelen 8/28/2006

When using the Custom Expression feature with a Access database it doesn't seem to work. Am I writing the expression correctly.

AuditID+' '+Division+' '+AuditYear


Maybe a tip: I use fieldnames like this _artikel+' ' +_demension and i get the same problem becouse of the underscore

C
clig 10/5/2006

When using the Custom Expression feature with a Access database it doesn't seem to work. Am I writing the expression correctly.

AuditID+' '+Division+' '+AuditYear


strUserID & " - " & Now()
works for concatenation