Re: [MS_AccessPros] Conditional formatting

Robin-

In your report, put this in the Control Source of the text box to display the number:

=IIf([Number] >= 1000, Null, [Number])

… where [Number] is the name of your field.

John Viescas, Author
Microsoft Access 2010 Inside Out
Microsoft Access 2007 Inside Out
Microsoft Access 2003 Inside Out
Building Microsoft Access Applications
SQL Queries for Mere Mortals
http://www.viescas.com/
(Paris, France)




On Jun 4, 2014, at 4:26 PM, Robin Chapple robinski@westnet.com.au [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:

I have a report that uses numbers in one field. I have a few records
where I need the field to show as blank.

Is the any way that I can apply a rule that numbers above 1000 do not
appear in print? I need them to still be in the record so that they
sort at the end of a numerical sort.

Many thanks,

Robin Chapple



------------------------------------
Posted by: Robin Chapple <robinski@westnet.com.au>
------------------------------------

Yahoo Groups Links







------------------------------------

------------------------------------

Yahoo Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/MS_Access_Professionals/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/MS_Access_Professionals/join
(Yahoo! ID required)

<*> To change settings via email:
MS_Access_Professionals-digest@yahoogroups.com
MS_Access_Professionals-fullfeatured@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
MS_Access_Professionals-unsubscribe@yahoogroups.com

<*> Your use of Yahoo Groups is subject to:
https://info.yahoo.com/legal/us/yahoo/utos/terms/