JimbobGilb
Posts: 28
|
| Posted: 11/09/2011, 11:47 PM |
|
I have an onvalidate function
If PickedItems.PartNumber.Text <> PickedItems.HPartNumber.text then PickedItems.Errors.addError("INCORRECT PART NUMBER")
But this appears to be case sensitive. It throws up "INCORRECT PART NUMBER" when field PartNumber is NH and HPartnumber is nh
This is all pulled from access database
What is the best way to make HPartNumber uppercase or tell the formula not to be case sensitive?
Thanks in advance,
|
 |
 |
TheunisP
Posts: 342
|
| Posted: 11/10/2011, 12:08 AM |
|
wrap both in either lcase() or ucuse()?
|
|
|
|
TheunisP
Posts: 342
|
| Posted: 11/10/2011, 12:13 AM |
|
for that matter ucase both if you want to make sure that it is uppercase equal
another idea is to ucase the field just before you insert and update - that way it is nice upcase everytime you display it in a grid or whatever
|
|
|
|
|
