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

Access Report formatting

P: 7
Hi Everyone,

I am working on an Access report and the client is asking for nitpicky things so I am working on a way to make this work. I have a couple questions and they are not related.

1. I have a date field which I formatted in the Format properties
dd" de "mmmm" de "yyyy.
I did this so that the date will display as follows:
02 de Febuary de 2008.
This works well, but now I need to change the capitalization of Febuary to lower case, so the whole word is lower case.

2. The report I am working on is basically a letter template to be mailed out. Since the original template was in word, and they needed to bring in Access data fields, so I built the report in Access.
The problem I face is when I try to bring in the Word text into Access. It treats it like an image object, so I had to paste it into Access and make it transparent and cram in the Access fields needed in the spaces of the paragraph. The field and the paragraph aren't aligning. One tap up and its too high, one tap down and its too low.

This is frustrating the hell out of me! Can anyone help?

Thanks,

-b
Feb 11 '08 #1
Share this Question
Share on Google+
3 Replies


MindBender77
100+
P: 234
Hi Everyone,

1. I have a date field which I formatted in the Format properties
dd" de "mmmm" de "yyyy.
I did this so that the date will display as follows:
02 de Febuary de 2008.
This works well, but now I need to change the capitalization of Febuary to lower case, so the whole word is lower case.
For this question I would try using Lcase. An example:
Expand|Select|Wrap|Line Numbers
  1. Lcase(me!control)
  2.  

Bender
Feb 11 '08 #2

jaxjagfan
Expert 100+
P: 254
Make a language conversion table and do a dlookup on month name. You could even make the language date format selectable at print time.

Just have someone familiar with the correct spellings give you the list of the month names.

I did a project whereas we worked with mixed currency types and I had to do conversions on the fly and the report had to display the correct currency symbols.(USD, CN, EU, YEN, NOK, SEK, BP, etc)
Feb 11 '08 #3

P: 7
I am kind of an Access newbie. How would I go about doing this? (Language Conversion Table).

-b
Feb 12 '08 #4

Post your reply

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