var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Query, Concatenate, Field width limit
I have a query that has a custom field that concatenates 4 other fields into one.
The custom field is being cut off at 255 characters. Is there any way to increase this field limit? Here is the custom field code:
cNote: First([custom1] & " " & tcomposite.date_created & [custom2] & " " & tcomposite.benchmark & [custom3] & " " & (Format(tcomposite.discretionary_account_cutoff,"$ 0,000.00")) & " " & [custom4])
I am using Access 2002.
This works in VBA so might work in a query.
Instead of joining all 4, join 2 and 2. Then join those two together to get the four you want.
Don't know why it works in VBA, it may also work in a query.
are you obliged to concatenate in the query?
if your concatenation is for display in a form/report you could concatenate in the text box itself.