Re: Separating text by carriage return

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance


Dmitriy Antonov wrote:
"Contro" <contro81@xxxxxxx> wrote in message
news:1139764352.851900.243210@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx

Contro wrote:

I don't know why you refuse combobox. This control (I mean the one in
MS
Access, since I understand the phrase "access text box" as you are
using MS
Access) has such functionality and it would be the simplest way to
achieve
your goal. You just need to prepare a list of possible entries. Since
you
have to have some criteria for selection, you can apply these criteria
to
prepare the list and populate combobox with it. And combobox doesn't
require
an entry from the list - it just have a property, which you can
OPTIONALLY
use to restrict selection to list items only.

Dmitriy.

So I could use a combo box to enter more than one value which isn't in
the list?

For example, I have a combo box with a list of values:

English
Mathematics
French

But as well as these I want to also choose Geography and German. Can I
then choose all five subjects from the combo box, even though only
three of them are listed in the combo box? I didn't think you could....

Also, I have realised that I will need to be able to do this without
using a combo/list box, as I will also want to choose a grade for each
subject, and those grades could be the same (this would be in another
text box).

So I am wanting a shortcut to show a sentence for getting a grade A.
So pressing "a" would then bring up the sentence "Achieved a grade A"

Please help! I'm sure this can't be that hard and has been done
before, but I'm just not sure how to do it.

Thank you again!

Contro.


Having this additional requirement, I would create a table with at least two
columns Subject and Grade and subform with Data*** view (or, perhaps, as
Continuous Form), where both columns are presented in the form of comboboxes
(I just guess, that you are using MS Access, because you never clearly
stated it). If the sole purpose of the form is to make this selection, then
you can construct the form as explained without use of subform. Combobox for
Subject has LimitToList=False and Grade has it set to True (since set of
grades is finite). You should clear this table before starting the selection
and/or after you finish with it, so information in the table exists
temporary - during the process of making all selections. When user finishes
with all selections (there should be some indication of it - some button or
just on Form unload) then final text is constructed based on such selection
(with optional validations - for No Entries, for example) and, as mentioned,
the table is cleared to be ready for the next selection. If concurrent work
is possible (in multi-user environment) then you should add some session
identifier to that table and filter and delete entries based on that
identifier.

Dmitriy.

Hi there!

Thanks for all your help on this. Basically, the reason I wanted it to
be the way I specified was because I'm having a lot of troubles with
the mail merge from the access database to a word document, where the
data is stored precisely in the database. So I was having to find
other solutions that would work. Also, the way I proposed is exactly
the same as the users have it now, and there are so many different
subjects that a list box would look pretty clumsy. Also, the people
using it would be using it day in day out, so any shortcuts, no matter
if there are similar subjects meaning the shortcuts are not as
intuitive as they could be, wouldn't matter; that problem occurs now
and it's not a problem, if that makes sense.

I've actually managed to find out what it was that I needed, and it
almost works okay (just a niggly visual basic problem to sort out now),
but would like to thank you for your help on this!

Just wish things were easier with all this computer stuff!

Contro.

.

Quantcast