Wierd Form Error

[Access_Headaches]

I just opened one of our databases and noticed that one of our text fields no longer had the scroll bar to see the entire data inside it.

Simple fix right? I just deleted the field and added it back and poof, the scroll bar appeared. The problem is, I got back more than I wanted. Now, all of my data has a </div> between each line among other random HTML looking code.

Not only did it show up on our form but it also added that data in our table! When I go to delete the code on our form, it just comes back after you re-open it.

Please help. Thanks in advance.

 

[boblarson]

Sounds like you are using either 2007 or 2010 and made a change from PLAIN TEXT to RICH TEXT in the control's properties (perhaps by accident). What that does is insert basically HTML markup (RTF is similar to HTML) and that is why you have all of that "garbage" so-to-speak in the fields.

 

[Access_Headaches]

Just checked the table and form, both are set at plain text. Switched it to rich, then switched it back, and still cannot clean up the garbage.

 

[Simon_MT]

Can you send an example, please.

Simon