check column Width and Row Hieght

Solaris

New member
Local time
Today, 12:38
Joined
Feb 27, 2011
Messages
6
Dear Experts.
How can i check a Specific COLUMN width in a table by VBA code and so on ROW height?
 
Code:
Set db = CurrentDb

a = db.TableDefs("table1").Fields("yo").Properties("ColumnWidth")
'twips first
MsgBox "Twips = " & a
'convert to inches
b = a / 1440
MsgBox "Inches = " & b
'convert to cm
c = b * 2.54
MsgBox "cm = " & c

Rows are a bit trickier
 
Last edited:
Thanx. it's working
 

Users who are viewing this thread

Back
Top Bottom