Wrox Programmer Forums
Access VBA Discuss using VBA for Access programming.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access VBA section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
Old June 17th, 2003, 06:01 AM
Registered User
Join Date: Jun 2003
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default Format datagrid

In vb6 you can edit a datagrid to include the fields that you wish to show - I did this using the data environment - amending the grid and then removing reference to the data environment and populating the grid with code.

How do I do this is Access (project) - I can populate using code but don't know how to manipulate the grid so that it shows the columns I wish it to show


Old June 18th, 2003, 02:16 AM
Authorized User
Join Date: Jun 2003
Posts: 15
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via MSN to psychadelic

Hello the world,

I think you cannot hide a column in a datagrid. I can't find any properties to do this. But you can find a way to work around this particular problem. Just build a query/stored procedure, add only the fields you want to use and bind it to the data control. Don't use a table because all the fields will show up in your grid.

One last thing, in Ms Access I would rather go for a subform linked to a table/query instead. But that's me ;)

Hope this helps


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to set a value in datagrid to currency format? jhansib4u ADO.NET 0 December 12th, 2007 01:43 AM
Datagrid - format a row jgferguson Beginning VB 6 0 May 25th, 2007 03:48 AM
Datagrid / DateTime Format Setting tanakrita ASP.NET 1.0 and 1.1 Basics 2 May 17th, 2007 09:56 PM
Datagrid Row format Fernb2000 Pro VB.NET 2002/2003 0 August 24th, 2005 01:21 PM
Format Datagrid column lamdog ASP.NET 1.0 and 1.1 Basics 4 March 23rd, 2005 09:37 AM

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.