By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
426,122 Members | 906 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 426,122 IT Pros & Developers. It's quick & easy.

Interesting - vertical date in Access 2007 report

tuxalot
100+
P: 200
Vertical date on my report shows #######

Other vertical text appears correct.....hmmmm ideas?
Mar 1 '09 #1
Share this Question
Share on Google+
2 Replies


puppydogbuddy
Expert 100+
P: 1,923
the date might be longer the vertical length allotted. Try increasing the vertical length a tad. If that does not fix it, maybe Stephen Leban's rotated text function may help.
http://www.lebans.com/rotatetext.htm
Mar 1 '09 #2

tuxalot
100+
P: 200
Increasing the vertical length worked. When using vertical text, it seems Access defaults to aligning the text way to the right. So the text field in report design view was large enough to contain the date, but in report preview it wasn't. I ended up setting the background to text box background to transparent and increasing the field 2 times the required height. This did the trick.
Mar 1 '09 #3

Post your reply

Sign in to post your reply or Sign up for a free account.