ascii esc character

Hi All. I'm trying to move a program from a mainframe to a pc. I need
to set up
long strings of ascii esc characters (hex 27). I can't figure out how
to define a field in a table to be this character by default or in
some fields many occurances of this character. Could anyone give me an
idea on how to do this? Thanks very much for your help. Ed Cassidy
University of Wyoming.

re: ascii esc character

Its only a guess, but I guess it is not possible because in Access the Esc
key is used to undo the changes to a field, or if used twice undoes all the
changes to a record. I guess it could get very confused. Probably OK with
any other unprintable character though.

Phil
"Ed Cassidy" <cassidy@uwyo.edu> wrote in message
news:a1aa7f80.0311210730.31399cf9@posting.google.c om...[color=blue]
> Hi All. I'm trying to move a program from a mainframe to a pc. I need
> to set up
> long strings of ascii esc characters (hex 27). I can't figure out how
> to define a field in a table to be this character by default or in
> some fields many occurances of this character. Could anyone give me an
> idea on how to do this? Thanks very much for your help. Ed Cassidy
> University of Wyoming.[/color]

re: ascii esc character

Get a single escape character with Chr$(27).

Get strings of them with String$(1000, Chr$(27)) - or vice-versa, I can't
remember the parameter order.

But why do you want escapes at all? What are you going to use them for?

HTH,
TC


"Ed Cassidy" <cassidy@uwyo.edu> wrote in message
news:a1aa7f80.0311210730.31399cf9@posting.google.c om...[color=blue]
> Hi All. I'm trying to move a program from a mainframe to a pc. I need
> to set up
> long strings of ascii esc characters (hex 27). I can't figure out how
> to define a field in a table to be this character by default or in
> some fields many occurances of this character. Could anyone give me an
> idea on how to do this? Thanks very much for your help. Ed Cassidy
> University of Wyoming.[/color]