Hi all,I would like to add a space in front of my text data.Old data:E67893456712345New data will be: E6789 34567 12345 Please help for that. Thanks,Blinda

Hi Blinda,Noticed you started another string.  I just posted a couple input masks to your previous post.  I have tested both and they work fine.  I provided two so that you can decide whether you want to type the decimal point when entering data or not.  And, you will not need to add a space in front of your existing data.The only other question I have is whether you were trying to put the input mask into the field in the table, or on a form?"Blinda" wrote:> Hi all,> > I would like to add a space in front of my text data.> > Old data:> E6789> 34567> 12345> > New data will be:>  E6789>  34567>  12345 > > Please help for that. Thanks,> > Blinda> > 

On Wed, 21 Mar 2007 15:46:05 -0700, Blinda wrote:> Hi all,> > I would like to add a space in front of my text data.> > Old data:> E6789> 34567> 12345> > New data will be:>  E6789>  34567>  12345 > > Please help for that. Thanks,> > BlindaA permanent change?Back up your database table first.As long as the field is Text datatype, you can run an Update Query:Update MyTable Set MyTable.FieldName = chr(32) & [FieldName]This is not do-able if the field is a Number datatype, as a space isnot a number.-- FredPlease respond only to this newsgroup.I do not reply to personal e-mail

Thanks. This field will be for both the table and the form. The input mask of CC99\.99! works perfect for all the data with two digits after the decimal point. but it does not work if I have nothing or only one digit after the decimal point. Could you please provide sugggestion for it. Thank you very much.  Blinda"FedBrad" wrote:> Hi Blinda,> > Noticed you started another string.  I just posted a couple input masks to > your previous post.  I have tested both and they work fine.  I provided two > so that you can decide whether you want to type the decimal point when > entering data or not.  And, you will not need to add a space in front of your > existing data.> > The only other question I have is whether you were trying to put the input > mask into the field in the table, or on a form?> > "Blinda" wrote:> > > Hi all,> > > > I would like to add a space in front of my text data.> > > > Old data:> > E6789> > 34567> > 12345> > > > New data will be:> >  E6789> >  34567> >  12345 > > > > Please help for that. Thanks,> > > > Blinda> > > >