MSFlexGrid

i success insert data into MSFlexgrid field. but leading space occur for each field. how should i remove the leading space and insert data located in left side.

i use LTRIM function to remove leading spaces but not working.
LVL 1
cyseng10Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

kapil_mohtaCommented:
could u provide the code u r using to insert the data ?

Kapil
0
CluskittCommented:
Format the field for text only. Will post back later to tell you how you can do this.
0
CluskittCommented:
Try:
MSFlexgrid.CellAlignment=flexAlignLeftCenter
If that doesn't work, please post the part of the code where you receive the data, and where you insert it into the grid.
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

cyseng10Author Commented:
i read data from text file and using Additem function insert data into MSFlexGrid Field.

the data might long. when i insert into field. i can't disply full length of data. how do i apply scrollbar to view full length of data?

the CellAlignment function and convert to text format is not working.
0
CluskittCommented:
MsFlexgrid.Wordwrap=true
MsFlexgrid.colwidth=Len(text)/2
MsFlexgrid.rowheight=20
This will adjust the size of the cell to two lines (You may have to fine-tune the rowheight property).
You might also want to make checks to see if the 2nd line won't reduce the colwidth from a previous text entry, but basically, that should take care of the display. Note that you can also divide it by 3 lines, etc. Just adjust as desired.
You can also make a variable to test the longest text length being inserted, and in the end adjust the colwidth.
Another possibility is, after testing the longest length being inserted, test it in a switch case statement, and from zero to value x, divide it in 2 lines, from x+1 to y, divide in 3, etc... Again, adjust as you desire.

Now, about the text part, it would be better if you could post the code for getting the text from the file, and for putting into the MSFlexgrid. That way, we could see how you are doing it, correct any possible mistakes along the way, and get a better understanding of how it works. If you could post a sample of the text file as well, it would be helpful (just a few lines should be enough).
0
cyseng10Author Commented:
Please closed the question as found solution by myself.

thank you for replying.
0
Computer101Commented:
PAQed, with points refunded (50)

Computer101
E-E Admin
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Programming

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.