Displaying a long text field in Infopath

[Newbie]

I have created an Infopath form linked to an Access data base. I have a text
field in the data base that is limited to 255 characters. It is bound to a
text box in my Infopath form. When I query the form, the Infopath text box
only displays the first 50 characters of the data resident in the data base.
If I retype the data (i.e. more than 50 but less than 255 characters) in into
the info path form however, it will overwrite the data base and the next
query of the form will display more all the characters (up to 255). I do not
have character length restrictions on my text box so I am at a loss here.
Can anyone help me out?

 

[Shiva (GGK Tech)]

--
Shiva
http://www.ggktech.com

 

[Newbie]

Shiva,

Thanks for the response. Unfortunately, rich text boxes do not let you
submit to a database. If you use rich text boxes and establish your data
connection to the data base the submit command will not let you write to the
database.

The data is simply text. To be more exact, it is a comment field where a
user can enter some quick notes about the information contained in the form.

Hopefully someone has run into this problem before.

Newbie

 

[Kalyan G Reddy MVP (GGK Tech)]

Hello

Delete the Field and try to add again a new field and connect it to Access
Db and Querry again.

 

[Shiva (GGK Tech)]

Hi,

Can you try to change the filed data type from string to rich text box? You
have to check your data is querying all 255 characters or not and what type
of data it is? Did it contain any special characters?