Datasheet Column Label Alignment

  • Thread starter Thread starter Rao
  • Start date Start date
R

Rao

Any suggestions on aligning the Label of a Datasheet
Column? By default it is aligning to Centre. The
requirement is to align it to Left or Right depending on
the need.

Rao
 
You can access datasheet objects & properties through code, with the
ActiveDatasheet object. That object has methods & properties the same as a
Form. I don't have Access here to check, so I can't give you exact code. But
this will give you the names of the top-level properties. Check those out,
then go from there:

(untested)

dim prp as property
for each prp in activedatasheet.properties '
SCREEN.activedatasheet.properties?
debug.print prp.name
next

HTH,
TC
 
Back
Top