Okay, this isn't hard 1

[jaburke]

Hi...
I have a field that looks like this:

489C

It's defined as a 6 char field, so it's actually '489C '. I want to make it ' 489C'. Help me with a formula to do this. I don't want to just do it in the formatting because I want to use ' 489C' in another formula. I know this isn't hard, but I'm going in circles.

Thanks!!

 

[lupins46]

Do all the records have 4 characters followed by 2 spaces?

 

[jaburke]

Nope...there's no pattern.

 

[lupins46]

Right(" " & left((mytable.myfield}, instr({mytable.myfield}, " ")-1), 6)

 

[kskid]

Try this

space(6-length(trim({table.field})))+trim({table.field})

-lw

 

[jaburke]

That seems to work.....Thanks!!!!!