Lookup returns unwanted HTML tags

[George]

Good Day all.
This code below return the correct string but with the HTML tags which are not in the original text

Function GetListDescription(lProductID As String) As String

GetListDescription = DLookup("[Description]", "Products", "[ID] = " & lProductID)




End Function


This is the output:

<div>Large Chair</div>

Can anyone explain this phenomenon?

[CJ_London]

sounds like your field is a memo field - change it to a text field

[George]

Thanks for the intervention.

I tried it but it limits the size of the entries. I wanted to enter much more data.

[CJ_London]

OK - then leave as a memo field and change the text format to plain text

[George]

Thanks. That works.