Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. MichaelBiddulph

    Way to allow different formats for different records in same field?

    MajP I have some code that basically divides the number entered by 100 to get around the 20 being displayed as 2000% which I know works but I can't get it to work with the calculated field in your code above. Any idea where I should trigger the code - doesn't work for AfterUpdate which is...
  2. MichaelBiddulph

    Way to allow different formats for different records in same field?

    MajP I'm trying to maintain a series of target values for each month of the year and the actual values achieved each month. The record has a detailed description of what is to be achieved and target, actual and variance fields for each month of the year. Some of the targets are percentages...
  3. MichaelBiddulph

    Way to allow different formats for different records in same field?

    MajP Thanks for that - it works but doesn't quite do what I want to do. What I'm seeking to do is to enter the Format value (from combobox) then enter a value and display the value correctly formated in the field I entered it. Hope that makes sense! All help gratefully received! Michael
  4. MichaelBiddulph

    Way to allow different formats for different records in same field?

    Hi Guys - I'm just a novice here but I want to do the same thing on a form - have some values as percentages, some as numbers and some as text. How would I do this? Michael

Part and Inventory Search

Back
Top