Re: Formatting a text field in report



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: Mail merged document changed values
    ... Word MVP web site http://word.mvps.org ... Make it currency data type and format. ...
    (microsoft.public.word.docmanagement)
  • Re: Mail merged document changed values
    ... In a table, e.g employees, create a field, I named it salary. ... Make it currency data type and format. ... I actually put it in twice, once no formatting and ...
    (microsoft.public.word.docmanagement)
  • Re: retaining ACCESS-formatted text in VISIO?
    ... You might be able to do this by changing the Data Type in the Column ... Settings dialog. ... Right click in the External Data window and choose Column ... When the query data is linked to shapes in VISIO2007, the formatting is ...
    (microsoft.public.visio.general)
  • Re: How can I create a site search?
    ... The first question is: what kind of server is the site hosted on?? ... Microsoft MVP FrontPage ... I must stick to fairly strict formatting ... the Web Search web component ...
    (microsoft.public.frontpage.client)
  • Re: Why can I not format a calculated field in a query to Currency
    ... you can drop the typecasting once you have set ... remove the formatting you have set. ... represents the calculation you already have. ... gives me any options for the data type. ...
    (microsoft.public.access.queries)