By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,949 Members | 946 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,949 IT Pros & Developers. It's quick & easy.

Problem with column in continuous form view

P: n/a
RLN
re: Access 2003

I have a field called SentByMethod the displays a 'zero', '1' or '2'.
I am trying to set up a text field that shows "Sent by X" if it's 0,
"Sent by Y" if it's 1, and "Sent by Z" if it's 2. I can get this to
work in single form mode (fields on the form)

How do I get this same thing to work when the form is in "continuous
form" view mode? (when row 1 has a SentByMethod of 0, row 2 has
"SentByMethod of 1....etc The text box needs to indicate the proper
SentByMethod.

Thanks.

Sep 15 '08 #1
Share this Question
Share on Google+
4 Replies


P: n/a
RLN wrote:
re: Access 2003

I have a field called SentByMethod the displays a 'zero', '1' or '2'.
I am trying to set up a text field that shows "Sent by X" if it's 0,
"Sent by Y" if it's 1, and "Sent by Z" if it's 2. I can get this to
work in single form mode (fields on the form)

How do I get this same thing to work when the form is in "continuous
form" view mode? (when row 1 has a SentByMethod of 0, row 2 has
"SentByMethod of 1....etc The text box needs to indicate the proper
SentByMethod.

Thanks.
I'd write a function.
Sep 15 '08 #2

P: n/a
Dunno if a change in display control is doable for you... but as the
count of variables is only 3, a combo-box may be a quick & dirty fix?
Create the combo box on the continuous forms form, then open its
Properties window

On the DATA tab:
Bind it to the SentByMethod Field
Change Row Source Type to Value List
Set value list to read: 0;SentByX;1;SentByY;2;SentByZ

On the FORMAT Tab:
change column count to 2
Set column widths to read: 0,1 (assumes columns in inches, We use cm
here in Aus.. so it'd be 0,2.5...but you get the picture..)

Like I say, Quick & Dirty but should do the trick without requiring a
whole bunch of code...

Dave
RLN wrote:
re: Access 2003

I have a field called SentByMethod the displays a 'zero', '1' or '2'.
I am trying to set up a text field that shows "Sent by X" if it's 0,
"Sent by Y" if it's 1, and "Sent by Z" if it's 2. I can get this to
work in single form mode (fields on the form)

How do I get this same thing to work when the form is in "continuous
form" view mode? (when row 1 has a SentByMethod of 0, row 2 has
"SentByMethod of 1....etc The text box needs to indicate the proper
SentByMethod.

Thanks.
Sep 16 '08 #3

P: n/a
As long as ***both*** fields are ***bound*** to the underlying table it
doesn't matter whether the form is continuous or not, simply use the same
code you used on the Single View form. If the textbox to display Shipped by X,
etc, is ***not bound*** to a field in the underlying table, you can't do it
at all. A hack such as Dave suggested would be your only choice, I'd think.

--
There's ALWAYS more than one way to skin a cat!

Answers/posts based on Access 2000/2003

Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ccess/200809/1

Sep 16 '08 #4

P: n/a
RLN
This worked nicely, Dave, thank you very much.

RLN
Sep 17 '08 #5

This discussion thread is closed

Replies have been disabled for this discussion.