Posted on 2003-11-19
Last Modified: 2012-08-13
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.
Question by:cyseng10
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions

Expert Comment

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

LVL 18

Expert Comment

ID: 9786446
Format the field for text only. Will post back later to tell you how you can do this.
LVL 18

Expert Comment

ID: 9788181
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.
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!


Author Comment

ID: 9792257
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.
LVL 18

Expert Comment

ID: 9796003
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).

Author Comment

ID: 10008980
Please closed the question as found solution by myself.

thank you for replying.

Accepted Solution

Computer101 earned 0 total points
ID: 10025284
PAQed, with points refunded (50)

E-E Admin

Featured Post

Enroll in May's Course of the Month

May’s Course of the Month is now available! Experts Exchange’s Premium Members and Team Accounts have access to a complimentary course each month as part of their membership—an extra way to increase training and boost professional development.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This is about my first experience with programming Arduino.
Computer science students often experience many of the same frustrations when going through their engineering courses. This article presents seven tips I found useful when completing a bachelors and masters degree in computing which I believe may he…
An introduction to basic programming syntax in Java by creating a simple program. Viewers can follow the tutorial as they create their first class in Java. Definitions and explanations about each element are given to help prepare viewers for future …
With the power of JIRA, there's an unlimited number of ways you can customize it, use it and benefit from it. With that in mind, there's bound to be things that I wasn't able to cover in this course. With this summary we'll look at some places to go…

751 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question