Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Forms Programming / January 2007

Tip: Looking for answers? Try searching our database.

Change datasheet column heading names

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Darrin - 15 Jan 2007 15:53 GMT
Hello:

I have a main form setup "myMainForm".  On this main form I have a subform
"mySubForm".  The subform is refreshed/requery after the user types in a
date such as "01/07/07" from the main form.  The subform is generated based
on a crosstab query that I create in VBA code on the fly.  The subform
displays employee time information for a given date and by job.  The main
reason I use a crosstab query is because there could be more than one job
that an employee has worked on for a given date.

Date-------EmpName----ST_Hours-----OT_Hours-----Hours_Job_abc------Hours_Job_123

Now for my question.  When the information is displayed in the data sheet
subform the job number field can get very long.  I would like the ability to
word wrap that label heading or come up with another solution.  I have tried
to change the properties of the label to "vertical" but it appears when in
datasheet view these changes have no bearing.  What can I do so the
datasheet column headings word wrap?

Thanks,

Darrin
Wei Lu [MSFT] - 16 Jan 2007 03:15 GMT
Hello Darrin,

I would like to know if Freeze the Column will resolve your problem.

Also, how about change your column width?

Sincerely,

Wei Lu

Microsoft Online Community Support

==================================================

Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications.

Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscriptions/support/default.aspx.

==================================================
(This posting is provided "AS IS", with no warranties, and confers no
rights.)
Wei Lu [MSFT] - 18 Jan 2007 10:31 GMT
Hi ,

How is everything going? Please feel free to let me know if you need any
assistance.

Sincerely,

Wei Lu
Microsoft Online Community Support

==================================================

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.

==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.