Input Mask and removing leading spaces

[Guest]

I have defined an input mask for a text field as:

!aaaaaaaaaaaaaaaa" code "9999

Which results in:

aname code 123

I need this to be updated and stored in the table left justified, ( able to
remove the leading spaces ). Removing the leading ! in the mask obviously
leaves a gap. The use of an LTRIM may be an answer but I am not sure how to
integrate this for entry to this field.

I am very new to the arcane world of access programs.

 

[Brett Collings [429338]]

I have defined an input mask for a text field as:

!aaaaaaaaaaaaaaaa" code "9999

Which results in:

aname code 123

I need this to be updated and stored in the table left justified, ( able to
remove the leading spaces ). Removing the leading ! in the mask obviously
leaves a gap. The use of an LTRIM may be an answer but I am not sure how to
integrate this for entry to this field.

I am very new to the arcane world of access programs.

Woodrow, I suspect you haven't had an answer because it's not really
clear what you are trying to do and what data it is that you are
trying to do it with.

The field looks very odd because you are mixing different bits of data
in the one field and this is what is giving you all this grief.

My suggestion is to have a name field and a code field. The name and
code are entered via a form of course and when you want to combine
them in a report, you just create a new object which just looks like a
field with the ControlSource being something like

=[NameField] & "code" & [CodeFieldName]

That's it, this is a much more structured way of breaking up your data
and later gives you the opportunity of searching and grouping on
[CodeFieldName]



Cheers,
Brett