I don't work with Access, so I don't know if this can be translated over to
your environment or not; however, from code within Excel, you can test the
Text property of a cell to see if the number fits or not. For example,
something like this...

MsgBox "Column too narrow? " & (Left(Range("H1").Text, 1) = "#")

--
Rick (MVP - Excel)


"PeteCresswell" wrote in message
...
I'm in MS Access VBA, creating a spreadsheet.

Is there any way for me to determine if I have populated a numeric
column with too many digits tb rendered?

i.e. the sheet will show something like "#########" in the column?