I have an Access 2007 ADP linked direct to SQL Server 2005 db.
On my form a I have a large text box bound to a SQL text column.
When my text box was formatted as plain text, when a user clicks in to edit existing text it seems to jump around a bit and lead to truncation of characters, or inadvertent input where what the use could see didn't seem to be what was actually in the column in the table - like a few hidden formatting characters were present in the data but not showing up on the form.
So I changed the text box to Rich Text and that issue seemed to go away, but now obviously Access is adding a large amount of HTML markup - divs etc, changing ampersands - I don't want all this extra!
Any better ideas for handling large amounts of text in a field that might contain line breaks or tabs etc, but won't jump around and corrupt the data?
Many Thanks
On my form a I have a large text box bound to a SQL text column.
When my text box was formatted as plain text, when a user clicks in to edit existing text it seems to jump around a bit and lead to truncation of characters, or inadvertent input where what the use could see didn't seem to be what was actually in the column in the table - like a few hidden formatting characters were present in the data but not showing up on the form.
So I changed the text box to Rich Text and that issue seemed to go away, but now obviously Access is adding a large amount of HTML markup - divs etc, changing ampersands - I don't want all this extra!
Any better ideas for handling large amounts of text in a field that might contain line breaks or tabs etc, but won't jump around and corrupt the data?
Many Thanks