[AccessD] another tab control issue

In case it's of interest, I have/had 2 forms with issues.

I have a option group with a label attached to the frame -- that label's font size is too large and it's location is too far right (to the right instead of left of the frame).  I deleted the label and created a new one that was not associated with the frame, and it's OK.

I have another form with 2 subforms, that are both datasheet view.  The 2 subforms' font size is increased, but the row height is not, so you cannot read the text.  You can, however, manually increase the row height.


The other 35 forms in the database that use resizing work great.

I disabled the double click code.  I have a main form switchboard (that actually has several levels of hierarchy) and double-clicking the screen activates the button handler.


Thanks again, 
Carolyn


----- Original Message ----- 
  From: A.D. Tejpal 
  To: Access Developers discussion and problem solving 
  Sent: Tuesday, May 17, 2011 11:08 PM
  Subject: Re: [AccessD] another tab control issue


      You are most welcome Carolyn!  

      Nice of you to provide the confirmation regarding successful outcome.

  Best wishes,
  A.D. Tejpal
  ------------

    ----- Original Message ----- 
    From: cjlabs 
    To: Access Developers discussion and problem solving 
    Sent: Tuesday, May 17, 2011 21:31
    Subject: Re: [AccessD] another tab control issue


    I've used Form_Resize on several on the forms, including the problem form and another form with a tab control, and they look great (ie, normal) in 2010.   Have to do a little tweaking, but that's nothing compared to having a tab control mangled beyond use by 2010.

    Now to change all the rest of them. . . .

    Thanks,
    Carolyn Johnson


      ----- Original Message ----- 
      From: A.D. Tejpal 
      To: Access Developers discussion and problem solving 
      Sent: Monday, May 16, 2011 11:29 PM
      Subject: Re: [AccessD] another tab control issue

      Carolyn,

          Amongst various alternatives, my sample db named Form_Resize (in access 2003 file format, reference: DAO 3.6), might be of interest to you It is available at Rogers Access Library. Link:
      http://www.rogersaccesslibrary.com/forum/forum_topics.asp?FID=45

          Apart from automatic resizing to suit current screen resolution, the sample offers custom resizing (up or down in steps of 5 percent) of any given form, if so desired by the user, with the option to freeze the custom size so that thereafter the form opens to custom size (over-riding the size dictated by actual resolution). At any stage the behavior can be reset to normal (i.e. automatic resizing to suit current resolution).

          Resizing is effected through a self contained class. Six styles of demo forms are included in the sample as follows:
          (a) Simple controls - all free to float and resize.
          (b) Simple controls - with certain controls having tag property settings for locking their position and / or size.
          (c) Combo box and list box.
          (d) Nested subforms - Continuous.
          (e) Nested subforms - Datasheet.
          (f) Tab control having (i) Nested subforms and (ii) Option group. Also - an option group directly on the form.

          Note:
          ------
          (a) The sample db has also been tested successfully on Access 2010. Resize behavior of tab controls on access 2010 is found to be different from that in access 2003 and the resize class in sample db duly caters for this peculiarity.    
          (b) It is observed that use of Times New Roman font provides most pleasing results.

      Best wishes,
      A.D. Tejpal
      ------------

        ----- Original Message ----- 
        From: cjlabs 
        To: Access Developers 
        Sent: Tuesday, May 17, 2011 02:01
        Subject: [AccessD] another tab control issue

        I have a form with a tab control that has worked normally for years in Access 2000, 2002, 2003, and 2007.   It has text boxes,  list boxes, labels and buttons on each of the 7 pages on the tab control.   

        I use ADH scaling code (been using it since Access97) and it has always worked fine.  On this particular form in Access2010, the scaling is screwed up -- the tab control is much wider than it should be, so that the rest of the controls end up in the wrong location and some are off screen.  I have other forms with similar tab controls in this database that scale correctly.

        If I do not use the scaling code, the form appears normal (just small).

        I've tried creating a new form and pasting the controls and code into it.  I've tried decompilng.

        Has anyone seen this behavior?  Any suggestions?

        TIA
        Carolyn Johnson
        St Louis MO
  -- 
  AccessD mailing list
  AccessD at databaseadvisors.com
  http://databaseadvisors.com/mailman/listinfo/accessd
  Website: http://www.databaseadvisors.com