Thanks Graham,
That worked a treat.
Regards,
Robin
At 5/06/2014 08:48 AM, you wrote:
Hi Robin
You can sort on the field, but make the ControlSource of the textbox something like this:
=IIf( [Fieldname]<1000, [Fieldname], Null )
Or, if you prefer to use conditional formatting, set the ForeColor to white.
Best wishes,
Graham
From: MS_Access_Professionals@yahoogroups.com [ mailto:MS_Access_Professionals@yahoogroups.com]
Sent: Thursday, 5 June 2014 09:27
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] Conditional formatting
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 1 000 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>
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (6) |
.
__,_._,___
Tidak ada komentar:
Posting Komentar