Hello,
I am having and issue with an ntext field. It seems to have a limitation on it.
Here is the history.
I am supporting a database that was created by a prior employee and I am now having some issues.
I have a MS Access front end connected to SQL back end. Connected through ODBC.
The filed is called [Comments] the data type on the SQL table is ntext. The field is located on [Table1].
The main issues is: the comments will not print in full. (however I have found other issues with this as well - see below)
There is a record that has a very large amount of text in the [Comments] field.
There is steps the users have to go through to add text to the [Comments] field.
There is a button on the main form that says [Add Comments] What happens there is a unbound form comes up with the claim number filled in and a blank area to type your text.
Then on the unbound form there is a button that says [Enter Comments]. What happens there is the current date and time with a new line is added to the [Comments] field on table with the text that was enterd into the unbound form.
The new text is put at the beginning of the field. I can use that method to add more commments.
What normally happens is the user will want to print their comments with the [Print Comments] button. What that does is just brings up a report with the comments in them. However with this record, it is cutting off the first 8 days of comments. (which is the first 8 entries of the comments field)
The other issues is when I went into the table to delete the "test" comments it tells me "the text is too long to be edited.
I also tried to modify the text directly in the SQL table and it does not show the comments in that field it just says <Long Text>.
Can anyone assist me with this issue?
I am having and issue with an ntext field. It seems to have a limitation on it.
Here is the history.
I am supporting a database that was created by a prior employee and I am now having some issues.
I have a MS Access front end connected to SQL back end. Connected through ODBC.
The filed is called [Comments] the data type on the SQL table is ntext. The field is located on [Table1].
The main issues is: the comments will not print in full. (however I have found other issues with this as well - see below)
There is a record that has a very large amount of text in the [Comments] field.
There is steps the users have to go through to add text to the [Comments] field.
There is a button on the main form that says [Add Comments] What happens there is a unbound form comes up with the claim number filled in and a blank area to type your text.
Then on the unbound form there is a button that says [Enter Comments]. What happens there is the current date and time with a new line is added to the [Comments] field on table with the text that was enterd into the unbound form.
The new text is put at the beginning of the field. I can use that method to add more commments.
What normally happens is the user will want to print their comments with the [Print Comments] button. What that does is just brings up a report with the comments in them. However with this record, it is cutting off the first 8 days of comments. (which is the first 8 entries of the comments field)
The other issues is when I went into the table to delete the "test" comments it tells me "the text is too long to be edited.
I also tried to modify the text directly in the SQL table and it does not show the comments in that field it just says <Long Text>.
Can anyone assist me with this issue?
Comment