[AccessD] Column Index

This is the code that I use in the form's class module:

Private Sub FormatDataSheetColumns()

    Me.RowHeight = 240 	' in twips

    txtJobNumber.ColumnHidden = True

    With cboAssoc_File_ID
        .ColumnHidden = False
        .ColumnOrder = 1
        .ColumnWidth = 1440	' in twips
    End With
    ' Set for all visible datasheet controls

End Sub

It demonstrates the four datasheet-specific display properties: RowHeight,
ColumnHidden, ColumnOrder and ColumnWidth

-Ken

-----Original Message-----
From: rsmethurst at UK.EY.COM [mailto:rsmethurst at UK.EY.COM]
Sent: Tuesday, February 17, 2004 8:24 AM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Column Index


Thanks Gustav,

That's the problem. The 'lead' column needs to be changed dynamically,
which is why I'm wondering if there is any way to do it programatically.
I've tried to set the tabindex already (in code) and it doesn't seem to
have had an affect.

Ryan




Gustav Brock <gustav at cactus.dk>
Sent by: accessd-bounces at databaseadvisors.com
17/02/2004 13:55
Please respond to Access Developers discussion and problem solving


        To:     Access Developers discussion and problem solving
<accessd at databaseadvisors.com>
        cc:
        Subject:        Re: [AccessD] Column Index


Hi Ryan

Switch to design mode and adjust the tab sequence of the textboxes.

/gustav

> I have a series of fields which appear in datasheet view on a form.  I
> would specifically like one of them to appear as the first column.  Is
> there  a method to programatically set this.

_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com






This e-mail and any attachment are confidential and contain proprietary
information, some or all of which may be legally privileged.  It is intended
solely for the use of the individual or entity to which it is addressed.  If
you are not the intended recipient, please notify the author immediately by
telephone or by replying to this e-mail, and then delete all copies of the
e-mail on your system.  If you are not the intended recipient, you must not
use, disclose, distribute, copy, print or rely on this e-mail.

Whilst we have taken reasonable precautions to ensure that this e-mail and
any attachment has been checked for viruses, we cannot guarantee that they
are virus free and we cannot accept liability for any damage sustained as a
result of software viruses.  We would advise that you carry out your own
virus checks, especially before opening an attachment.

The UK firm Ernst & Young LLP is a limited liability partnership registered
in England and Wales with registered number OC300001 and is a member
practice of Ernst & Young Global.  A list of members? names is available for
inspection at 1 More London Place, London, SE1 2AF, the firm?s principal
place of business and its registered office.