Memo/Text

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

Guest

I have an access database connected to a front-end in Infopath. In my
access db, I have memo data types which Infopath does not support. Is
there anyway I can break up the memos into mutiple text fields, but
still appear as a paragraph still (> 255 char.)??
 
I do not know if it will work for Infopath but build a temp table that is
split- say at 250 interval into field1, field1, and field3.

Use a Maketable query for the trial --
Left([YourMemo],250) right(left(YourMemo],500),250)
right(left(YourMemo],750),250)
into field1 into field2
into field3


Your output query would be --
[field1]&[field2]&field3]
 
Back
Top