How to Count the Characters of a Field?

[Frank Dulk]

I want to discover how many times the bar (/) appears inside of the field
numnota

how do I do?

 

[Frank Dulk]

As I make this function?

you could write a vba routine using a for loop to len of field value and
count using instr(myfield,"'") > 0.

 

[Mike Painter]

You have to use the Instr function and loop through the string.

 

[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

 

[Dirk Goldgar]

Here's a quick and doubtless inefficient method, but it's a cute
one-liner:

lngCount = UBound(Split([numntota] & " ","/",,vbBinaryCompare))