B
Blaze
I have an Infopath form that has 3 pieces of confusing entry. It is a form
that has 2 fields that aren't making sense.
The first (#1) is a repeating table with 6 fields, includes Name, Address,
City, State, Zip, Phone.
The second (#2) is a single text field that has narrative information in it.
This is setup to have paragraph breaks and expand automatically selected.
The people can type all the required text in here and it shows correctly.
The third (#3) is a single text setup just like the #2. This is used to
fill out a quick description of another optional section.
I post these as a submit to a sharepoint site where I "plug" access in to
"harvest" the data so that I can report it in a formatted way. All this
works well!
The Sharepoint site shows all the text for #1 and #3 and there is no
truncation.
The Sharepoint site truncates #2 at 255 characters, which is the only one I
need everything.
When I use Access to look at the linked table, it says that the #1 and #3
are "memo" fields and that #2 is a "text" field. I have tried everything I
can think to get it to give me the correct type of data. Please give me some
clue as to what tells sharepoint whether it is "memo" or "text". I really
need the #2 data out of the form so that I can report the narrative.
Thank you,
Blaze
that has 2 fields that aren't making sense.
The first (#1) is a repeating table with 6 fields, includes Name, Address,
City, State, Zip, Phone.
The second (#2) is a single text field that has narrative information in it.
This is setup to have paragraph breaks and expand automatically selected.
The people can type all the required text in here and it shows correctly.
The third (#3) is a single text setup just like the #2. This is used to
fill out a quick description of another optional section.
I post these as a submit to a sharepoint site where I "plug" access in to
"harvest" the data so that I can report it in a formatted way. All this
works well!
The Sharepoint site shows all the text for #1 and #3 and there is no
truncation.
The Sharepoint site truncates #2 at 255 characters, which is the only one I
need everything.
When I use Access to look at the linked table, it says that the #1 and #3
are "memo" fields and that #2 is a "text" field. I have tried everything I
can think to get it to give me the correct type of data. Please give me some
clue as to what tells sharepoint whether it is "memo" or "text". I really
need the #2 data out of the form so that I can report the narrative.
Thank you,
Blaze