Results 1 to 5 of 5
  1. #1
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Newbury, Berkshire, England
    Posts
    712
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Datasheet gets wider (AK2)

    The following code opens the form

  2. #2
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Sint Niklaas, Belgium
    Posts
    2,778
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Datasheet gets wider (AK2)

    Rupert,
    the culprit is the line :
    .DatasheetFontHeight = 8
    Don't ask me why or a solution, I don't know, but if you comment it out, it will stop growing.
    Francois

  3. #3
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Newbury, Berkshire, England
    Posts
    712
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Datasheet gets wider (AK2)

    It appears that once you

  4. #4
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Newbury, Berkshire, England
    Posts
    712
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Datasheet gets wider (AK2)

    Would I be correct in assuming that the reverse of adding properties (added by the createproperty method) is possible? Is there a destroy property method? If there is, how would I go about it?

    I got this idea from the help shown in the previous post:

    >>>>>>>>>or you can add them in an Access database (.mdb) by using the CreateProperty method and append it to the DAO Properties collection.<<<<<<<

    I want to reset my datasheet back to its default behaviour.

  5. #5
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Sint Niklaas, Belgium
    Posts
    2,778
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Datasheet gets wider (AK2)

    I don't understand what MS means in his helpfile.
    As I understand the DataSheetFontsHeight is a property of the form.
    Any way, if you use the following code the growing is also stopping :

    If .DatasheetFontHeight <> 8 Then
    .DatasheetFontHeight = 8
    End If
    Francois

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •