CODEWITHSUNDEEP
ms-access
ConnerB
ConnerB

Reputation: 3

Text comes in wrong in Access form

I have an inventory database. When I enter a description (24" Monitor) on a form it looks as it should. When I open another form with the description, it comes in as

<div>24&quot, Monitor</div>

Any ideas why this is happening and how to fix it?

Upvotes: 0

Views: 66

Answers (1)

Tarun. P
Tarun. P

Reputation: 442

In your Inventory Database the Description field is set as Memo field.

If you try to get the values from memo field into a plaintext than you will get the text as HTML Format as above.

To avoid any confusion make sure what you would like to achieve. Either set the Textbox TextFormat Property from plaintext to Richtext or Change the datatype of the Description field from longtext (Richtext) to longtext (Plaintext) or change to ShorT Text.

Upvotes: 1

Related Questions