seperating columns in a text box into multiple text boxes?

[Greg Doudna]

Berney:

You probably are better off doing this separating in the query data source
for your form. You can use string commands to find which character position
your comma separator is in, then use the Left$ and Right$ functions to
separate the string into two separate pieces. These fields will be
non-updateable.




"berney" <bradford@shawgrp.com> wrote in message
news:9b7901c34642$10d360a0$a401280a@phx.gbl...

> I would like to seperate a text box that contains 2
> column into 2 seperate text boxes?

[John Vinson]

On Wed, 9 Jul 2003 10:46:46 -0700, "berney" <bradford@shawgrp.com>
wrote:

>I would like to seperate a text box that contains 2
>column into 2 seperate text boxes?

Is this on a Form? in a Table? in a text import?

How are the columns defined? By a delimiter, such as a commma or
space; or by a column count?

What's the underlying table structure?

John W. Vinson[MVP]
Come for live chats every Tuesday and Thursday
[url]http://go.compuserve.com/msdevapps?loc=us&access=public[/url]