cpbsmw
Last Activity: Oct 14 '06, 07:53 PM
Joined: Oct 12 '06
Location:
-
Addition
I need help adding to 2 seperate fields. I know this seems as simple as 1+1. However lets say field one has a name of A and has a value of "1" and field two has a name of B and has a value of 2. If i simply do in field 3 =[A]+[B] i actually get "12" instead of three. I have tried to use "Sum" but i have found that no matter what is in the first field i simply get a return value of what ever is in field with an addition... -
Conditional formatting works if you only have 3 condition. I potentially have dozens of seperate values that can appear within the same control. That is why i know this can be done with 'Select Case', but i have been unable to figure out how to write the code. Example of written code would be of great help. -
Color Changes
I need to write a code that causes the background color and text color of a control when its value changes. for example if the word in the control is Afghanistan i need the background color to be black and font to be white, whereas if the word is USA i need the background color to be green and the font to be black. I think i can do this with Select Case but i can not figure out how to write the code for this. Any help is appreciated.
...
No activity results to display
Leave a comment: