Conditional Formatting - Comparing field on form to field on a different table
in [Form]
|
From: Jay on 24 Feb 2010 17:55 I have [form1] linked to [table1] which has field [address] I would like to conditional format field [name] (on [form1]) if [form1]![address] matches any [address] field in [table1] I tried using Dlookup in the condition field but couldn't get it work. TIA, J
From: Linq Adams via AccessMonster.com on 24 Feb 2010 21:33 If you have a field or control designated NAME you have to change this! NAME is a Reserved Word in Access VBA and using it will cause you major problems, sooner or later! As to your question, is Form1 in Single, Continuous or Datasheet View? -- There's ALWAYS more than one way to skin a cat! Answers/posts based on Access 2000/2003 Message posted via http://www.accessmonster.com
From: Jay on 24 Feb 2010 23:17 Thanks Linq, I do not have any fields called NAME. This was just an example to keep things simple. My form is in Normal (Single) view but I would also be curious if I could do the same thing in Datasheet view. -----Original Message----- From: Linq Adams via AccessMonster.com [mailto:u28780(a)uwe] Posted At: Wednesday, February 24, 2010 6:33 PM Posted To: microsoft.public.access.forms Conversation: Conditional Formatting - Comparing field on form to field on a different table Subject: Re: Conditional Formatting - Comparing field on form to field on a different table If you have a field or control designated NAME you have to change this! NAME is a Reserved Word in Access VBA and using it will cause you major problems, sooner or later! As to your question, is Form1 in Single, Continuous or Datasheet View? -- There's ALWAYS more than one way to skin a cat! Answers/posts based on Access 2000/2003 Message posted via http://www.accessmonster.com
|
Pages: 1 Prev: Cannot shange width of form Next: unbound textbox value derived from subform |