Hi,
I want to format an unbound box based on the value of another field. I know how to write the expression [Other_Field] = "Text" However, I want to format the box if there's any value at all in the other field. How do I write that?
Hi,
I want to format an unbound box based on the value of another field. I know how to write the expression [Other_Field] = "Text" However, I want to format the box if there's any value at all in the other field. How do I write that?
try expression =: Not IsNull([Other_field])
Could also check the length
Please use # icon on toolbar when posting code snippets.
Cross Posting: https://www.excelguru.ca/content.php?184
Debugging Access: https://www.youtube.com/results?sear...bug+access+vba
Thanks all, they both work.![]()