Search results

I tried that new solution, but it caused an error in report. Thank you anyway!

That worked, thanks. I thought I had tried that and received an error stating that it was a variable mismatch, but it worked now.

The solution works in most cases. I had found a similar one. However, one of the cases (I should have added originally), does not contain any numbers. The cell content may be (few examples): Box NA 05 mL 10 mL The code works as a control source for the report for the last 2 examples, but not...

I am trying to prevent display of the first character in a field, but only if the first character is a zero. So for example, I have a field named ContainerSize, and some of the data listed in the underlying table are as follows: 05 mL 30 mL 05 mL ID 10 mL ID I would like to have the data...

Very clever. Thanks again.

Thanks Paul! That worked fine. What does the (")-1)) accomplish (the "new" info you added)?

I've tried that but had difficulty creating the "IIF". Each time I try I get an error. =IIF((InStr(1,[ProductName],”(“)-1=False, Left([ProductName],(InStr(1,[ProductName],"(")-1)),[ProductName])).

Thank you for the suggestion. I used =Left([ProductName],(InStr(1,[ProductName],"(")-1)) which worked well for items that had a supplier but caused an error if there was no "(". Thank you for your help.

I am trying to limit the data displayed on a packing slip. The ItemName field contains the name of the item and our supplier. For example, "Hubcap (Ford)". The supplier's name is always in parentheses. I would like the report to simply display "Hubcap" without the "(Ford)". I don't know how to...