Control Source If statement

ms-access vba ms-access-2003
Ish picture Ish · Jun 5, 2012 · Viewed 12.4k times · Source

I want access to automatically calculate the output if the entered value is > 0. So I put the following code in the "Control Source" field of a textbox property and it is giving me an error. The Number should be obtained from Text052 and it should output it in Text054.

Here is the code:

If Text052.value > 0 then
Text054.value = Val([Text052].[Value])/2
end if

Error: "The expression you enetered contains invalid syntax". "You have enetered the operand without the operator"

I am not sure how to write the syntax in the control source field of the text box propety. Please advice.

Answer

Fionnuala picture Fionnuala · Jun 5, 2012

In the control source of Text054, try:

=IIf([Text052] > 0,[Text052]/2, "N/A")

"N/A" can be whatever you need, including null.

Related questions

Now() function with time trim

So the function =Now()....is there a way I can use this and only get the date, not the time? or is there just a function for this idea?

Read More
VBA Code to Close an Access Database Without Leaving a Shell of the application open

I'm currently using Application.Quit which leaves a shell of the MS Access Application open. After processing the calling function against the target application, I am left with every instance of the application remaining open still; even though the specific …

Read More
how can i populate textbox through VBA in MS Access

I have a table RR_info which hold following fields RR_ID, HR_ID, No_of_Beds, Room_Category. Now i want that through VBA code with Form_load event I should populate textboxes for all these table fields. For …

Read More