Posts Topics Forums Images
Search videos from message boards Videos Search messages from microblogs Microblogs Search messages from imdb.com Imdb Search messages from yuku.com Yuku Search messages from lefora.com (free forums) Lefora
My account: Login | Sign Up
Loading... 

Thread: conditional formatting a text field in microsoft.public.access
Started 1 month, 3 weeks ago by BABs
not sure what i am missing I have a position field that if the word 1st is anywhere in it I want it to turn red. It is a text data type I have tried field value is equal to like '*1st*' just '*1st*' not sure what I am doing wrong??? - not turning red.- and yes I se the formatting to red?? I am sure my syntax ...
Site: Discussions in microsoft.public.access  Discussions in microsoft.public.access - site profile
Forum: microsoft.public.access  microsoft.public.access - forum profile
Total authors: 2 authors
Total thread posts: 3 posts
Thread activity: no new posts during last week
Domain info for: microsoft.com

Other posts in this thread:

Beetle replied 1 month, 3 weeks ago
Change the condition from Field Value Is to Expression Is, then in the criteria box put; [YourFieldName] Like "*1st*" -- _________ Sean Bailey "babs" wrote: > not sure what i am missing > I have a position field that if the word 1st is anywhere in it I want it to > turn red. It...
Size: 1,129 bytes
Customize:  Customize "<b>Reply 1</b>: conditional formatting a text field in microsoft.public.access :: microsoft.public.access :: Discussions in microsoft.public.access"

BABs replied 1 month, 3 weeks ago
Thanks it works!!!! "Beetle" wrote: > Change the condition from Field Value Is to > Expression Is, then in the criteria box put; > > [YourFieldName] Like "*1st*" > > -- > _________ > > Sean Bailey > > > "babs" wrote: > > > not sure what i am missing > > I have a ...
Size: 1,338 bytes
Customize:  Customize "<b>Reply 2</b>: conditional formatting a text field in microsoft.public.access :: microsoft.public.access :: Discussions in microsoft.public.access"

 

Top contributing authors

Name
Posts
BABs
2
user's latest post:
conditional formatting a text...
Published (2009-11-07 08:55:00)
&nbsp; Thanks it works!!!! &quot;Beetle&quot; wrote: &gt; Change the condition from Field Value Is to &gt; Expression Is, then in the criteria box put; &gt; &gt; [YourFieldName] Like &quot;*1st*&quot; &gt; &gt; -- &gt; _________ &gt; &gt; Sean Bailey &gt; &gt; &gt; &quot;babs&quot; wrote: &gt; &gt; &gt; not sure what i am missing &gt; &gt; I have a...
Beetle
1
user's latest post:
conditional formatting a text...
Published (2009-11-07 07:15:00)
&nbsp; Change the condition from Field Value Is to Expression Is, then in the criteria box put; [YourFieldName] Like &quot;*1st*&quot; -- _________ Sean Bailey &quot;babs&quot; wrote: &gt; not sure what i am missing &gt; I have a position field that if the word 1st is anywhere in it I want it to &gt; turn red. It is a text data type &gt; &gt; I have tried field value is equal to like '*1st*'...

Related threads on "Discussions in microsoft.public.access":

Print Conditional Formatting in microsoft.public.access  Discussions in microsoft.public.access - site profile microsoft.public.access - forum profile Print Conditional Formatting in microsoft.public.access
Print Conditional Formatting in microsoft.public.access
Conditional formatting in microsoft.public.access  Discussions in microsoft.public.access - site profile microsoft.public.access - forum profile Conditional formatting in microsoft.public.access
Conditional formatting in microsoft.public.access
Make a text box border color change with conditional...  Discussions in microsoft.public.access - site profile microsoft.public.access - forum profile Make a text box border color change with conditional formatting in microsoft.public.access
Make a text box border color change with conditional formatting in microsoft.public.access
Programmable Data Entry & Conditional Formatting in...  Discussions in microsoft.public.access - site profile microsoft.public.access - forum profile Programmable Data Entry & Conditional Formatting in microsoft.public.access
Programmable Data Entry & Conditional Formatting in microsoft.public.access
How to apply conditional formatting of one field to whole...  Discussions in microsoft.public.access - site profile microsoft.public.access - forum profile How to apply conditional formatting of one field to whole record in microsoft.public.access
How to apply conditional formatting of one field to whole record in microsoft.public.access
Conditional formatting for a differnet field in...  Discussions in microsoft.public.access - site profile microsoft.public.access - forum profile Conditional formatting for a differnet field in microsoft.public.access
Conditional formatting for a differnet field in microsoft.public.access

Related threads on other sites:

Conditional Formatting - Excel Tutorials: Learn how to...  Twitter / designforum - site profile design forum - forum profile Conditional Formatting - Excel Tutorials: Learn how to use Conditional Formatting in Microsoft Excel... http://tinyurl.com/5cqmue about 14 hours ago from twitterfeed
Conditional Formatting - Excel Tutorials: Learn how to use Conditional Formatting in Microsoft Excel... http://tinyurl.com/5cqmue about 14 hours ago from twitterfeed
Conditional Formatting in microsoft.public.access.macros  Discussions in microsoft.public.access.macros - site profile microsoft.public.access.macros - forum profile Conditional Formatting in microsoft.public.access.macros
Conditional Formatting in microsoft.public.access.macros
Conditional Formatting in Microsoft Access 2003 [SOLVED]  PC Pitstop Forums - site profile User to User Help - forum profile Conditional Formatting in Microsoft Access 2003 [SOLVED]
Conditional Formatting in Microsoft Access 2003 [SOLVED]
My First IIF expression and conditional formatting... in...  Discussions in microsoft.public.access.gettingstarted - site profile microsoft.public.access.gettingstarted - forum profile My First IIF expression and conditional formatting... in microsoft.public.access.gettingstarted
My First IIF expression and conditional formatting... in microsoft.public.access.gettingstarted
Output Format to pdf does not maintain conditional...  Discussions in microsoft.public.access.gettingstarted - site profile microsoft.public.access.gettingstarted - forum profile Output Format to pdf does not maintain conditional formatting in microsoft.public.access.gettingstarted
Output Format to pdf does not maintain conditional formatting in microsoft.public.access.gettingstarted
Conditional Formatting in...  Discussions in microsoft.public.access.gettingstarted - site profile microsoft.public.access.gettingstarted - forum profile Conditional Formatting in microsoft.public.access.gettingstarted
Conditional Formatting in microsoft.public.access.gettingstarted
View rules and conditional formatting in...  Discussions in microsoft.public.infopath - site profile microsoft.public.infopath - forum profile View rules and conditional formatting in microsoft.public.infopath
View rules and conditional formatting in microsoft.public.infopath
Please help - hide control and control header with...  Discussions in microsoft.public.infopath - site profile microsoft.public.infopath - forum profile Please help - hide control and control header with conditional formatting in microsoft.public.infopath
Please help - hide control and control header with conditional formatting in microsoft.public.infopath
Conditional formatting in microsoft.public.infopath  Discussions in microsoft.public.infopath - site profile microsoft.public.infopath - forum profile Conditional formatting in microsoft.public.infopath
Conditional formatting in microsoft.public.infopath
Conditional Formatting in microsoft.public.nl.office.excel  Discussions in microsoft.public.nl.office.excel - site profile microsoft.public.nl.office.excel - forum profile Conditional Formatting in microsoft.public.nl.office.excel
Conditional Formatting in microsoft.public.nl.office.excel
Thread profile page for "conditional formatting a text field in microsoft.public.access" on http://www.microsoft.com/communities/newsgroups.... This report page is a snippet summary view from a single thread "conditional formatting a text field in microsoft.public.access", located on the Message Board at http://www.microsoft.com/communities/newsgroups.... This thread profile page shows the thread statistics for: Total Authors, Total Thread Posts, and Thread Activity