please could you explain how to do this.use the formart property - for numbers there are 4 options, positive, negation, zero and null, separated by a semi colon.
don't know what other values you have but perhaps something like this
0.00;0.00;[red]"Stock"
one of the control properties is format - just copy paste the code I provided into itplease could you explain how to do this.
Nodo i still use conditional formatting - field value is?
As I've said there are 4 states for numbers, so assuming your shortage is indicated by a negative value then usethen use this if I have more options such as stock or shortage or if i need to add more?
I see it is both zero and null, not just null. Thanks.@MajP I do not think you can use the format property to handle 0 - yes, you can
i get an operand without an operator errorYou can do something like this. I do not think you can use the format property to handle 0. I have two textboxes on top of each other to make this work.
[0].[00;red]"Status";[red"Stock"]one of the control properties is format - just copy paste the code I provided into it
No
@MajP I do not think you can use the format property to handle 0 - yes, you can.
i dont understand the code but not sure if this will work, i need to reference the 2 status controls to 2 different controls in the form
yes, i need to compare other fields to the 2 different scenariosI've no idea where you are going with my suggestion - the code you are using a) seems to be in the wrong place and b) is nothing like what I provided.
this
[0].[00;red]"Status";[red"Stock"]
should look like this
0.00;[red]"Status";[red]"Stock"
Suggest you go with MajP's suggestion since I suspect I do not understand what it is you actually require - you seem to be wanting to reference other fields or controls
if a value in a control is 0, i want to display Stock in the control and not the actual value
which is what you would use the format property for - solution already providedif a value in a control is 0, i want to display Stock in the control and not the actual value
above is what I triedthis is what I have tried
# =iff([OTR5C QRY]![Stock Avilable]>[OTR5C QRY]![Reqmt Qty1],"Stock") #
# =iff([OTR5C QRY]![Stock Avilable]<[OTR5C QRY]![Reqmt Qty1],"Shortage") #
but i get a #Name? error
My apologies CJ_London. Works greatwhich is what you would use the format property for - solution already provided