Search results

I am trying to round a number. For example, I need 25.365 to round up after the 5. Currently, 25.365 is only rounding to 25.36 instead of 25.37. Can anyone help with this? Thanks Somehow this is working now. I don't know what the problem was. Thanks. [This message has been edited by...

I calculated a number in a field and I am trying to get the number to format as such: If the calculated answer is 25, I would like it to format as 25.00 instead of 25 It is calculating as an integer and I do not want it to do that. Also, my table is formatted as a text field and I must keep it...

I only want a user to enter either a number, decimal point, or negative operator in the the first three positions in the control. This is the code I used: Dim MyNumber MyNumber = Left(FieldName, 3) If MyNumber = "A through Z" Then MsgBox "Non-numeric characters are not allowed in this...

I am trying to prevent a user from entering a negative operator at the end of a field ina form. For example, if the user puts .2548- or 3.21- instead of -.2548 or -3.21. I am limited in what I can do with this because my tables must be set up as text fields. Also, this field is not a currency...

I have a form that I would like to allow the user to search data from the form's table by Name and Date. How would I get started with this? Would I have to create another table? Thanks David. You're THE BEST!! [This message has been edited by JennJenn (edited 05-22-2002).]

Making an Integer a Single I have a calculated field that does the following: After the calculations are performed, for example fld1 is 2.5 plus fld2 is 2.4 plus fld3 is 2.3(2.5 + 2.4 + 2.3), the result(fld3) gives 7 instead of 7.2. How can I make the field give 7.2(as a double or single)...

I am trying to prevent a user from entering a "-" sign at the end of a number in a field. For example, if the 81- was entered instead of -81. Am I on the right track with this: If Mid(FieldName, Length(FieldName) -1) then FieldName.Value = "-" & Mid(FieldName, 1, Length(FieldName)-1) End If