Detecting MEMO field

[Lorenzo Bolognini]

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

 

[PB4FUN]

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

 

[Bob Barrows]

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

The best way is to check the Field's Type property. If you go here:
http://www.able-consulting.com/ADODataTypeEnum.htm, you will see the data
mappings between the ADO datatype constants and the corresponding native
datatypes for a few databases (including Access). So, if the Field's Type
property contains 201 (adLongVarChar) or 203 (adLongVarWChar), then it's a
Memo field.

Bob Barrows

 

[Lorenzo Bolognini]

Thanks very much to both!

Lorenzo