Solved

MSFlexGrid

Posted on 2003-11-19
8
1,710 Views
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.
0
Comment
Question by:cyseng10
8 Comments
 

Expert Comment

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

Kapil
0
 
LVL 18

Expert Comment

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

Expert Comment

by:Cluskitt
ID: 9788181
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
Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
LVL 1

Author Comment

by:cyseng10
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.
0
 
LVL 18

Expert Comment

by:Cluskitt
ID: 9796003
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
 
LVL 1

Author Comment

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

thank you for replying.
0
 
LVL 1

Accepted Solution

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

Computer101
E-E Admin
0

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

This is an explanation of a simple data model to help parse a JSON feed
Entering a date in Microsoft Access can be tricky. A typo can cause month and day to be shuffled, entering the day only causes an error, as does entering, say, day 31 in June. This article shows how an inputmask supported by code can help the user a…

830 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