469,963 Members | 1,974 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,963 developers. It's quick & easy.

Access Report formatting

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
3 1792
MindBender77
234 100+
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
254 Expert 100+
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
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.

Similar topics

5 posts views Thread by Andrew Chanter | last post: by
1 post views Thread by rainxy | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.