Hello all,

Consider the following code:

Private Sub Form_Load()
Dim test As Variant
test= Space(5)
test= "8"
MsgBox Len(header)
End Sub

The msgbox gets a length of 1. My question is, is there a way to make it keep a length of 5, by have something like " 8" (4 spaces) put into the variable automatically? ie, have it automatically fill up the not used spaces rather than throwing them out?

Sunny