Search results

Yep that's done it. Many thanks.

Access is automatically 'rounding up' numbers as I enter them in my text box on my form. Eg, 11.5 becomes 12. I see that in the Properties of the text box, if I choose 'Currency' then it does not round up, but then it has a currency sign next to the number, which is not applicable in this...

Access is automatically 'rounding up' numbers as I enter them in my text box on my form. Eg, 11.5 becomes 12. I see that in the Properties of the text box, if I choose 'Currency' then it does not round up, but then it has a currency sign next to the number, which is not applicable in this...

Missinglinq and Bob - it's perfect, it works beautifully. Thank you so much for saving me days of hopeless searching. I will never ever put spaces in my field names again, and I promise always to use the VB editor, in honour of you both! Efharisto para poli, kai filakia, Lisa

Missinglinq, I have followed your instructions, but I'm getting an error message. Here's exactly what happens. Noting your recommendation to store the value in a field in my table, I created a new text field in the table called *[Wholesale Price GBP]*, and put it on my form. (Its data type is...

On the form, I put a text box. In the text box, I typed =[Price GBP website]-[15 percent] (the 15 percent field already has a calculation in it). This returns the total I need, but I need to be able to overwrite it, sometimes. So the calculation, in this case, is done in the form. I have...

Sorry Rabbie, I don't understand. I haven't used Lost-Focus before, I found it in the properties, events, list and played around a bit but got nowhere. If I understand you correctly (and I probably don't), the wholesale price of every product is different, so entering it into the properties of...

It's a calculated field on a form. I've also tried it in a normal field, bound to a query, but still it doesn't allow me to overwrite. Tks.

It's a calculated field on a form. I've also tried it in a normal field, bound to a query, but still it doesn't allow me to overwrite. Tks.

It's a calculated field on a form. I've also tried it in a normal field, bound to a query, but still it doesn't allow me to overwrite. Tks.

Hi everyone. I have a calculated field which I would like to be able to over-write the data if applicable. It's a number field which calculates 15% discount on another number field (giving the wholesale price for a product). Some products, however, have more than 15% discount, and I have the...