Code to delete character after update

[D2K2VIC]

In my Access DB form, I scan data into a field using a scanner. However, the data contains an extra character, a comma, that needs to be deleted after the field is updated and the focus moves to the next field. This will be the only character that will ever need removal and it is the final character in my data. Any help on the code? Thanks.

 

[Andrew Fergus]

Go into the form design, right click the 'barcode' (or whatever you have called it) field -> Properties -> Event Tab -> After Update -> Click the ... button to activate the Builder -> Code Builder -> Ok -> enter this (without the two outermost quotes) "[barcode] = IIf(Right([barcode], 1) = ",", Left([barcode], Len([barcode]) - 1), [barcode])" -> Save and close the VB window -> Save the form.

The code should look like this (before you close the VB window):

Private Sub barcode_AfterUpdate()
[barcode] = IIf(Right([barcode], 1) = ",", Left([barcode], Len([barcode]) - 1), [barcode])
End Sub

But please note that I used the field name 'barcode'

HTH, Andrew.

 

[D2K2VIC]

Andrew, many thanks, works like a charm!