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...

This application interfaces with another and in order for the spacing, etc. to sync correctly with the other system, this is the way it had to be designed. I figured it out. I formatted the code with Format(expression, "###0.00") Thanks [This message has been edited by JennJenn (edited...

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...

Birdy, can you send this to me too?

This application interfaces with another one and in order for the data in both systems to sync properly, this is the way it had to be set up. I really wish that I could change it but I have to work around 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).]

Same Here. You all have been so much help! Thanks a bunch!

I realized that all I had to do is create a customized input mask(#99.99;0) that would only allow the user to enter a "-" sign in the front of the number. Using this, the user cannot put -00.00...only 00.00). Thanks for your help!

Thanks so much David! Problem Solved!!

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