473,320 Members | 1,829 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

Using VBTab

3
Does anyone know how to use a number with VBTab?
Its to display in a list box but name how many spaces to jump across? In comal it is Tab(30) that would move the cursor to position 30.
Nov 3 '08 #1
5 6218
debasisdas
8,127 Expert 4TB
try the followin
Expand|Select|Wrap|Line Numbers
  1. Dim TestString As String
  2. ' Returns a string with 10 spaces.
  3. TestString = Space(10)
  4. ' Inserts 10 spaces between two strings.
  5. TestString = "Hello" & Space(10) & "World"
  6.  
Nov 3 '08 #2
TOD3
3
TY for reply. Its not quite wot im lookin for. If I was to have several columns in a listbox i need to know exactly wer the 2nd column is starting. e.g
Name Age
Bob 18
Fiona 23

Both hav 10 spaces between them and the columns are uneven. I need to code the actual tab margin starting number to guarantee even columns.
Nov 4 '08 #3
debasisdas
8,127 Expert 4TB
if you are fetching data from database then it can be easily achieved by using some of the string function in SQL.
Nov 4 '08 #4
TOD3
3
No its just to display output from arrarys to be displayed under 3 headings in a lisbox. Mite use 3 listboxes if I cant get it
Nov 4 '08 #5
debasisdas
8,127 Expert 4TB
you can fetch one item from array and format them as desired using some string functions like LENGTH.
Nov 4 '08 #6

Sign in to post your reply or Sign up for a free account.

Similar topics

6
by: campwes | last post by:
Hey, all. I'm trying to develop a C# app that creates Word 2003 mail merge documents with an Oracle 9i database as the datasource. I used the following as an example of how I can start out: ...
1
by: aevans1108 | last post by:
Greetings All If this is the wrong place to post this question, please give me a push in the right direction. Thanks. I know there has to be a simpler way to do this, but this is as simple a...
19
by: bdt513 | last post by:
I am trying to extract the values from a query using VBA. Specifically, I want to concatenate all the values of the "rosEmail" field from query "qselRosterEmailList" into one string (strEmails). I...
11
by: Grasshopper | last post by:
Hi, I am automating Access reports to PDF using PDF Writer 6.0. I've created a DTS package to run the reports and schedule a job to run this DTS package. If I PC Anywhere into the server on...
2
by: Mori | last post by:
Can some one translate this into C# for me: myString = "This is some text" & vbTab & "and some more text...." I cannot find an example of Tab characters being used. I've posted something...
0
by: Microsoft NewsGroups | last post by:
I am creating a TAB delimited file with .XLS extention using the Response.ContentType = "application/ms-excel" method. Normally I would place this on it's own form and delete all the HTML in the...
6
by: ransoma22 | last post by:
I developing an application that receive SMS from a connected GSM handphone, e.g Siemens M55, Nokia 6230,etc through the data cable. The application(VB.NET) will receive the SMS automatically,...
2
by: trezraven | last post by:
I am creating a template in Word 2007 using Visual Basic Editor. I am pulling information from an Access database. I know this is probably a stupid question, but for the life of me I can't figure out...
0
by: praveenhathwar | last post by:
Hi, I have a flexgrid with few data. Now I want that to be print in DOS Mode (To be print on Notepad), Preview it for the user and prevent the user from modifying the data in it. Is there any...
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
0
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.