2. ASPRunnerPro General questions
  3. more than 256 characters?
This topic is locked

more than 256 characters?

 		3/29/2007 7:56:15 PM
ASPRunnerPro General questions
P
 Philip author

Hi
I'm using version 4.1 / 221 together with an Access DB. I built a in Access a query with a calculated field that gathers as one string the content of several fields.

Example: string_hunde-cyno: "1) " & Meldestelle_Agility!S_SektionsName & " " & [A_Spezial] & " " & "2) " & [Taglang] & ", " & .....
My problem: ASPRunner cuts off everything behind 256 characters (I tried to use this string field on the VIEW page as text or HTML).

Any suggestion how I can VIEW (or EXPORT or PRINT) the full length (approx. 1000 characters) of the field?

Or do I have to try another approach? My goal is to have it in one string to have it ready for users to "copy & paste" the string.
Thanks - Philip
J
 		Jane 3/30/2007

Philip,
it seems that this is MS Access limitation. The result of concatenation should be less then 256 symbols.
Here is a workaround

  • don't use calculated field in your query
  • join your field on the Visual Editor tab. Just drag and drop your fields in one table cell.
P
 		Philip author 3/30/2007

Jane

thanks for answer.

  • It doesn't seem to be an Access limitiation (there I have the full string; seems as Access treats it similar to the field type memo).
  • Workaround: Hm... won't work in this case because I have to add between the fields some characters; only then the string makes sense
    Philip
J
 		Jane 3/30/2007

Philip,
you can add any symbols betweet fields in the Visual Editor --> HTML mode.

Here is an example:

1) {$row.1FieldName1_value}2) {$row.1FieldName2_value}
P
 		Philip author 3/30/2007

Thanks, Jane - this will work.

Philip