Change datasheet column heading names

[Darrin]

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]]

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]]

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.