F
Frank Dulk
I want to discover how many times the bar (/) appears inside of the field
numnota
how do I do?
numnota
how do I do?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
F
Frank Dulk
As I make this function?
msmcnewsxp said:you could write a vba routine using a for loop to len of field value and
count using instr(myfield,"'") > 0.
M
Mike Painter
You have to use the Instr function and loop through the string.
M
msmcnewsxp
pick an event for the control like lostfocus
dim x as integer
dim y as integer
for x = 1 to len(numnota.value)
if instr(mid(numnota.value,x,1),"/") > 0 then y = y + 1
next x
dim x as integer
dim y as integer
for x = 1 to len(numnota.value)
if instr(mid(numnota.value,x,1),"/") > 0 then y = y + 1
next x
D
Dirk Goldgar
Here's a quick and doubtless inefficient method, but it's a cute
one-liner:
lngCount = UBound(Split([numntota] & " ","/",,vbBinaryCompare))
one-liner:
lngCount = UBound(Split([numntota] & " ","/",,vbBinaryCompare))