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
Post a Comment