Re: Formatting a text field in report

Access General Questions
http://www.microsoft.com/office/community/en-us/default.mspx?dg=microsoft.public.access&lang=en&cr=US

Access Reports
http://www.microsoft.com/office/community/en-us/default.mspx?dg=microsoft.public.access.reports&lang=en&cr=US


laurenm wrote:

Thanks, Beth. I will give this a try.

I would love to go to an Access-specific Newsgroup but when I go the the Newsgroups area from the Microsoft site, there is no newsgroup that I see that can satisfy general Access questions. Am I missing something?

"Beth Melton" wrote:


"laurenm" <laurenm@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:726418EF-11C9-452D-A511-637A16BC44BA@xxxxxxxxxxxxxxxx

Hi Beth,

It is a text field because in this report, my fields are based on a query
results where I created a format expression that gives me a specific format
not available in the default date/time format. If changing the field to a
date/time format will matter to help me bold the results, I can change it to
a date/time field and stick with an Access default. Please advise.

The built-in formats, such as Short Date, are based on your Regional Settings in your Control Panel.

If you want to use a specific format then just type it in the format property: mm/dd/yyyy


What I am trying to do is display a project schedule where my results
consist of projected dates of completion and actual completion dates (if
there is a completed date to a task, I show the completed date, not the
original projected date). In order to visually tell which dates are completed
and which are projected I use a different format for each kind of date. The
projected dates I show as a mm/dd/yy format and the completed dates show as
mm/dd/yyyy format. I would like to bold the completed dates so it is even
easier to distiguish between the two types of dates. Can someone give any
insight as to how to do this (if it is even possible).

You should have this separated in two fields, one for completion and one for projected. Or, if your projected completion date is based on a calculation of another date, such as start date, then use a calculated field instead.

Then in your query for the field on your report use something like:

ReportDate: Nz([CompletionDate],[ProjectedDate])

Then just use a Conditional format for the ReportDate text box using an Expression such as: [CompletionDate] Is Null

Also note there are newsgroups dedicated to Access. If you have any future questions you'll likely find faster responses by posting to one of the Access newsgroups. :-)

Please post all follow-up questions to the newsgroup. Requests for assistance by email can not be acknowledged.

~~~~~~~~~~~~~~~
Beth Melton
Microsoft Office MVP

Word FAQ: http://mvps.org/word
TechTrax eZine: http://mousetrax.com/techtrax/
MVP FAQ site: http://mvps.org/


Thanks!
LaurenM

"Beth Melton" wrote:


My first question is why you are storing a date as a Text data type
and not a Date/Time data type. Or is this a concatenated string?

Perhaps if you told us more about what you are trying to do exactly we
might be able to help.

Please post all follow-up questions to the newsgroup. Requests for
assistance by email can not be acknowledged.

~~~~~~~~~~~~~~~
Beth Melton
Microsoft Office MVP

Word FAQ: http://mvps.org/word
TechTrax eZine: http://mousetrax.com/techtrax/
MVP FAQ site: http://mvps.org/


"laurenm" <laurenm@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:1DD98D1B-63A8-430A-8E6E-5F94A51D8A37@xxxxxxxxxxxxxxxx

Hi All,

Is there a way to change the formatting in a report text field based
on the
field meeting certain criteria? For example, if my text field has
the date
format of "mm" & "/" & "dd" & "/" & "yyyy", then apply a bold
format. I
looked into the conditional formatting but it didn't work for me.
Maybe I am
setting it up incorrectly. If anyone knows how to do this (if it can
be done)
please let me know.

Thanks,
LaurenM






.

Relevant Pages

  • Re: SBS User Email weird issue... (Sorry for long delay)
    ... Microsoft CSS Online Newsgroup Support ... Format of the e-mail to HTLM. ... Rich Format, Plain Format, please select Rich Format. ...
    (microsoft.public.windows.server.sbs)
  • Re: Format of addresses in personal letters
    ... please post all follow-ups to the newsgroup so ... it is not a standard MS format thats for sure. ... >> Microsoft MVP ... Several lines of typing in each address ...
    (microsoft.public.word.newusers)
  • Re: Formatting a text field in report
    ... Newsgroups area from the Microsoft site, there is no newsgroup that I see ... results where I created a format expression that gives me a specific ... Microsoft Office MVP ... MVP FAQ site: http://mvps.org/ ...
    (microsoft.public.office.misc)
  • Re: Formatting a text field in report
    ... Newsgroups area from the Microsoft site, there is no newsgroup that I see ... results where I created a format expression that gives me a specific ... Then in your query for the field on your report use something like: ... Microsoft Office MVP ...
    (microsoft.public.office.misc)
  • Problems in open new browser
    ... I am soory that I don't know I posted in right newsgroup or not. ... I just make the contenttype = "application/vnd.ms-excel" ... when he tried to export that report, the report just open a while (within ... I have tried to export other report, which also in excel format, from other ...
    (microsoft.public.inetserver.asp.general)