datasheet

  • Thread starter Thread starter Pierre
  • Start date Start date
P

Pierre

Hi,
I have an activedatasheet open as a subform in a form.

I just want to increase the size of the fonts for all the cells in one
shot.

Is it possible

Regards,
Pierre
 
Hi Pierrre,

There are 2 ways that I know of.

1. As a menu change & will affect ALL Datasheets in your program.

Go into TOOLS / OPTIONS / Then select "Datasheet" TAB
From there you can change the Font Size as well as many other properties of
a Datasheet. This will affect ALL Datasheets when they are viewed.


2. Programatically, with VBA code
See these articles...

1) Michael Kaplan has an excellent article on manipulating Datasheets here:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsmart01/html/sa01b1.asp

2) An API solution is here:
http://www.lebans.com/autocolumnwidth.htm

Regards,
Jeff
 
Back
Top