S Solaris New member Local time Today, 12:38 Joined Feb 27, 2011 Messages 6 Feb 27, 2011 #1 Dear Experts. How can i check a Specific COLUMN width in a table by VBA code and so on ROW height?
SpentGeezer Pure Noobism Local time Today, 19:08 Joined Sep 16, 2010 Messages 258 Feb 27, 2011 #2 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: Feb 27, 2011
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
S Solaris New member Local time Today, 12:38 Joined Feb 27, 2011 Messages 6 Feb 28, 2011 #3 Thanx. it's working