Adding additional characters to an existing product number

[streub]

The unique product number assigned to each inventory item must be preceded with "V0000" if the existing product number has five characters and "V000" if the existing product number has six characters. I need to make this change to the existing table(s) and to new entries in then future by means of a form.



I don't know where to start.

Thank you

Steven

[pbaldy]

An update query can be used for existing records. An expression like:

IIf(Len(FieldName) = 5, "V0000", "V000") & FieldName

[isladogs]

Use a similar idea for the form

If Len(fieldname)=5 Then
   me.FieldName="V0000" & me.fieldname
ElseIf Len(FieldName)=6 Then
   Me.FieldName = "V000" & me.FieldName
Else
'do nothing 
End If

Substitute your field name in the code
Note that the else if statement prevents the code running again if it's already been applied
The final Else clause is only there to explain the idea. It can be deleted as it does nothing

[Micron]

and to new entries in then future by means of a form.

Is it possible that in the future, values will be longer than 6 or less than 5?

[streub]

The recommendations are exactly what I need. I just could not remember the coding terms.

There may be less than four or more than six in the future but I retire in 18 months. Who cares then?

Thank you all.

Steven

[pbaldy]

I retire in 18 months.

Lucky bugger.