Hi there,

I am trying to fill an Excel cell with a variable from an access database. The database definition of this field is memo.

After 255 characters the variable gets truncated.

Does anybody know how to get all data and not only 255 chars?

Many thanx!!!!

The source code I use is:

Dim PROBLEEMOMSCHRIJVING As Variant
PROBLEEMOMSCHRIJVING = ALPR00PF("POAANL") 'i.v.m. >255 chars

BEREIK = "F" & RIJNUMMER
sExcel.Worksheets(WERKBLAD).Range(BEREIK).Value = PROBLEEMOMSCHRIJVING