Re: Formatting a text field in report

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.

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).

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: Formatting a text field in report
    ... 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. ... 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 ... MVP FAQ site: http://mvps.org/ ...
    (microsoft.public.office.misc)
  • Re: Date / Time customizing columns?
    ... Chart view with the Entry table applied, you can change the date/time format ... TIA, Colin D. ...
    (microsoft.public.project)
  • Re: Date / Time customizing columns?
    ... Chart view with the Entry table applied, you can change the date/time format ... TIA, Colin D. ...
    (microsoft.public.project)
  • Re: Formatting a text field in report
    ... 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 ... MVP FAQ site: http://mvps.org/ ...
    (microsoft.public.office.misc)
  • Re: Footer formatting, custom?
    ... >I have modified the standard footer created in a report so that the 2 ... > the date/time format that I use all the time by putting this in the ...
    (microsoft.public.access.gettingstarted)