Problem with RichTextBox and Access Db

  • Thread starter Thread starter Matt Burland
  • Start date Start date
M

Matt Burland

I have an application that gets data from a Access database and displays it
on a form. I have a slightly odd and annoying problem that stems from the
fact that the program I'm replacing with my program was writing in VBA in
Access. The problem is that the RichTextBox control in Access uses '/n/b' as
an end of line character while the RichTextBox in C#.NET uses just '/n'. The
reason why this is a problem is because it tricks my app into thinking that
a field has been changed because between moving the data from the database
to my RichTextBox control and then back to the database again all the end of
line characters get changed.
Now dealing with this would be very simple, but I have code that checks each
control and tries to determine if really has changed before updating the
dataset and I want a solution that is very general and doesn't require me to
cludge up my program with a lot of checks for this one case. Any ideas?
 
what about a filter to clean the /b off of all the records in your database, then you have clean data and your current app works fine.
 
Thanks for the reply. I think ultimately that's going to be the best
solution, but for right now I'm in the transition between the old Access app
and my app because there is a LOT that the old app can do that I still
haven't got around to in my new app. I guess I might just have to put up
with it for now.


Denton said:
what about a filter to clean the /b off of all the records in your
Click to expand...
database, then you have clean data and your current app works fine.
 
Back
Top