vba - how do I retain a leading zero when concatinating values in MS Access? -


i running concatenation of 2 fields number fields formatted 00. intended add leading 0 numbers 1-9. in form have begun concatenate these 2 losing leading 0.

private sub partcodebtn_click() dim groupval string dim catval string  groupval = me!prt_groupds.form![group_number] catval = me!part_cat_ds.form![partcat_number]  part_type_code = groupval & " " & catval 

i getting part type code result of 32 1 instead of 32 01. know how keep leading zero, or why have lost it?

i take part_type_code string, try:

part_type_code = format$(groupval, "00") & " " & format$(catval, "00") 

Comments