Assuming your Recorset is calle RS and you want to detect the first field
use this :
FS = RS.Fields(0).DefinedSize
For a normal string value you will get a max of 255, where you have a larger
value for a memo field (536870910)
So after that you do this :
If FS < 256 THEN
'Code for textbox"
ELSE IF FS > 500000000 THEN
'code for textarea
END IF
Meindert, MCP
"Lorenzo Bolognini" <lo*****@mysurname.net> wrote in message
news:oq*********************@news1.tin.it...
Hi all,
i'd like to know if there is some way to detect whether a field is of type
MEMO (i'm using MS Access) so to behave accordingly placing a textarea
instead of a textbox in the UI.
Thank You,
Lorenzo