If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Memo/Text
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.)?? |
#2
|
|||
|
|||
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] "abc" wrote: 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.)?? |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Memo/Text | abc | General Discussion | 0 | July 5th, 2005 02:30 PM |
memo/text box | IkyL234 | General Discussion | 0 | May 16th, 2005 10:47 PM |
DISTINCT on a Memo/Text Field | kw_uh97 | Running & Setting Up Queries | 1 | October 15th, 2004 09:09 PM |