Search results

Well... there are actually 4 price fields for each record, I don't even want to think to double those fields up. It's amazing... I've browsed like 20 pages of threads, but no luck..! There must be a smart way to do it, via VBA or something...

I have a continuous form with a currency field (price) that I need to format it to 4 decimal places if it is less than 1 and to 2 decimal places if it is greater than 1. How difficult can this be? iif(int([me.price])=0,Format([me.price],"#,##0.0000€"),Format([me.price],"#,##0.00€"))However, the...

I had to come back to this and close it... I ended up using the Before Update event. It is the most suitable for this kind of operations.

Hello all, The following modules are from a Continuous Forms view form. I want to check the TSTATUS and if it is 'S02' to provide the option of selecting a Vendor from the TSinfo. Then I want to check again for a null value, allowing however the option of a null value, if the user exits TSinfo...