[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 242
  • Last Modified:

I need help hiding a column in an Access datasheet

Hi Experts,
I use the code below to load an unlinked datasheet in my Access 2013 application.  I want to be able to hide the first column in the datasheet (the JobID.Column).  How can I do this?
Private Sub LoadJobVenues()
    Dim strSQL As String

    strSQL = "SELECT tblJob.JobID, tblJob.JobName, tblJob.JobtartDate,, tblJob.JobEndDate FROM tblJob WHERE (((tblJob.JobID)= " & intJobID & "));"
    
    Me.dataDisplaySubform.SourceObject = "Query.qryJobs"
    Me.dataDisplaySubform.Form.RecordSource = strSQL
    Me.dataDisplaySubform.Requery
    
    Me.dataDisplaySubform.Form.AllowEdits = False
    Me.dataDisplaySubform.Form.AllowAdditions = False
    Me.dataDisplaySubform.Form.AllowDeletions = False
End Sub

Open in new window


Thanks in advance,
mrotor
0
mainrotor
Asked:
mainrotor
1 Solution
 
Pratima PharandeCommented:
you need to try something like  

Me.FieldName.ColumnHidden = True


refer for more details

http://www.mrexcel.com/forum/microsoft-access/520734-hide-field-column-subform-datasheet-view.html
0

Featured Post

Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now