can Memo field be used in cascading comboboxes

[macaulayrg2003]

Hi,


I have created a db with cascading comboboxes that use text field. but my text boxes are too small now, some of new statements are >255 characters, but a memo field will take them. can i use memo field in a cascading combobox like i have done with text field.

cheers all

[June7]

The data will truncate.

What have textboxes to do with the comboboxes?

[Missinglinq]

As June7 said, the data will be truncated to the same 255 characters. But more importantly, it seems highly unlikely that any piece of data needed for a Cascading Combobox could exceed this figure. One of the caveats in the successful use of Memo Fields is that they should never be used to store any data that will ever need to be to searched, sorted, parsed, or in any way manipulated; they are intended to be used for free-hand 'memos' or notes. If any of the pieces of info need any of the actions in red be done to them or by them, those pieces of data need to be in their own, discrete fields.

A plain language explanation of exactly what you're trying to accomplish, here, would probably go a long way towards helping us help you, which is a our goal, here!

Linq ;0)>

[macaulayrg2003]

ID	Statements	Type
1	A minimum of approved cotton suit, overshoes, gloves and hat, are to be worn at all times whilst in any controlled area.	PPE
3	Wet protective PPE, as advised by E/SSHP, is to be worn when there is a risk of potential liquid contamination. If any spillages occur, a contamination (smear) survey is to be undertaken and a copy passed to ES3.	PPE
4	If there is no risk of liquid contamination, then the requirement for nitrile gloves can be relaxed for intricate electrical work.	PPE
5	When work on primary system valve caps or contaminated test rigs caps, if water is found, a gross swab is to be taken and single bagged and is to be monitored by E/SSHP for activity.	PPE
6	L60 portable air sample (PAS) is to be undertaken for airborne contamination.	Air Sample
7	Once samples have been proven clear, RPE requirements may be relaxed as advised by E/SSHP and ES3. DHPO is to be contacted out of hours.	Air Sample
8	If permission to relax RPE is given then it is to be annotated within the RPM adjustment section of the RPM.	Air Sample
9	L60 portable air sample (PAS) is to be undertaken for airborne contamination, during cutting/grinding operations. PAS is to be carried out for 10 mins for initial cut/grind and then repeated every 15 mins thereafter for duration of cutting/grinding operat	Air Sample
10	Whilst RC APD is shut down, L60 PAS are to be taken prior to any RC entry. They are to be repeated hourly as required.	Air Sample
11	E/SSHP is to be in attendance during cutting/grinding operations and L60 set up within close proximity of the work site.	Air Sample
12	A minimum of FFP3 mask and goggles are to be worn, and personnel are to be in date for face fit test.	RPE
13	All individuals must wear appropriate RPE for which they are in date for face fit/brief. (For tornado and FFP3 further guidance available from MCO team leader)	RPE
14	Only E/SSHP, NSI and personnel involved in the cut should be in the controlled area and the vicinity of the cut until the area has been proven clear.	RPE
15	During extensive cleans where dust/airborne hazard could be generated, RPE is required.	RPE
16	A Contamination Survey, (smear survey), is to be undertaken of the work area prior to any work taking place. If contamination is found, the area is to be decontaminated by E/SSHP and re-surveyed until clear.	Cutting & Grinding
18	Catchments are to be rigged and sufficient absorbent material used to the satisfaction of E/SSHP and checked on a regular basis if in continuous use.	Catchments
20	A suitable and robust catchment with high level side walls is to be established directly below with walls above the worksite and sufficient absorbent material used to the satisfaction of E/SSHP and checked on a regular basis whilst in continuous use.	Catchments
21	Personal Electronic Dosemeters are to be worn whilst working in controlled contamination and radiation areas.	Dosimetry
22	A Contamination Survey is to be undertaken of the work area on completion of the Cut/Grind. If contamination is found, the area is to be decontaminated by E/SSHP and re-surveyed. All contamination surveys are to be passed to ES3.	Surveys
23	Carry out a Radiation / Contamination (smear) survey of PET on receipt and disconnection of PET.	Surveys
24	Weekly radiation and contamination survey must be in date before all RC entries and RC state board updated, and surveys passed to ES3.	Surveys
25	A pre work radiation survey is to be carried out at worksite. If dose rate exceeds 2.5 µSv/hr a ‘Controlled Area’ is to be established, and a copy of the survey is to be passed to ES3.	Surveys
26	A Contamination Survey is to be undertaken of the work area on completion of the task. If contamination is found the area is to be decontaminated by E/SSHP and re-surveyed.	Surveys
27	Radiation survey to be conducted during and after all discharge operations, if dose rates exceed 2.5 µSv/hr then a controlled area to be established immediately.	Surveys
28	Time spent in a controlled area is to be kept to a minimum and stand-off areas are to be utilised.	Time
29	Portable shielding is to be in place and agreed with E/SSHP before commencement of work.	Shielding
30	Portable shielding is not to be removed or altered without first obtaining permission from E/SSHP.	Shielding
31	E/SSHP to resurvey should shielding be moved or altered.	Shielding
32	Shield Tag is to be attached to portable shielding.	Shielding
33	Care is to be taken to help minimise contamination or spill during venting and draining operations. If any spills occur a contamination survey is to be undertaken to assess and limit its spread.	Rigs
34	E/SSHP is to be in attendance when breaching primary systems and during the removal of rigs. On completion of the task, a “work site” contamination survey is to be undertaken, and a copy passed to ES3.	Rigs
35	Following disconnection, all hoses must be emptied of any liquid into a carboy with absolute filter.	Rigs
36	All hoses must be fitted with leak tight cap/plug and polybagged, rigs are to be fully vented and drained to a carboy fitted with an absolute filter. Sufficient absorbent material must be placed in polybag	Rigs
37	When work on primary system valve caps or contaminated test rigs caps, if water is found, a gross swab is to be taken and single bagged and is to be monitored by E/SSHP for contamination.	Rigs
38	Following disconnection, all hoses must be emptied of any liquid into a carboy with absolute filter. The hoses must then be fitted with leak tight cap / plug and poly bagged.	Carbouys
39	Before removal to APF, carboys are to have the absolute filter removed and cap replaced and double bagged containing absorbent material.	Carbouys
40	E/SSHP is to be in attendance when breaching primary systems and during the disconnection of rigs.	Carbouys
41	Following disconnection, all hoses must be emptied of any liquid into a carboy with absolute filter. The hoses must then be fitted with leak tight cap/plug and poly-bagged. Sufficient absorbent material must be placed in polybag.	Carbouys
42	The area is to be checked for Potassium Chromate using the Potassium Chromate testing kit supplied by ESHP Chemists. If Potassium Chromate is detected the area is to be cleaned and re-tested.	Potassium Chromate
43	Polythene is only to be used for bagging up equipment or rubbish and care must be taken to ensure that it cannot come into contact with primary systems. Polythene is slippery, a fire hazard and has a low melting point.	Polythene
44	No item, which is to be cleared in the tunnel, is to be monitored through polythene due to the significant attenuation of beta radiation.	Polythene
45	If there is any doubt regarding the item (e.g. suspected internals) then the item must be sent to the APF.	Polythene
47	Only items highlighted (in 4.4.4 in Procedure Guidelines) may be transferred to barrier unbagged. Using gloves place item on appropriately demarcated polythene surface.	Polythene
49	All surfaces are to be monitored using contamination probe as directed in General Monitoring Guidelines Paragraphs 4.3.	Polythene
51	If the results of the direct probe are 5 cps or greater (above background), the item is considered to be contaminated. Item is to be bagged immediately and the laydown area checked for contamination. Bagged item will be transferred to APF.	Polythene
52	Any contamination found is to be recorded in the RC Contamination/Clearance Log and the HP Supervisor contacted for further advice.	Polythene
53	If the direct probe results are less than 5 cps (above background) the item is to be gross wiped.	Polythene
54	Gross wipe every item on all surface areas, take wipe and place on the beta contamination probe surface for 5 second.	Polythene
55	Any item giving a reading of 5 cps or greater above background will be considered to be contaminated. Item is to be bagged immediately and the laydown area checked for contamination. Bagged item will be transferred to APF.	Polythene
56	Any contamination found is to be recorded in the RC Contamination/Clearance Log and the HP Supervisor contacted for further advice.	Polythene
57	To minimise the possibility of cross contamination the monitor must check him / herself.	Polythene
58	If the results of the direct probe and gross wipe are less than 5 cps (above background), the item can be considered to be free of contamination and suitable for free release.	Polythene
59	Record item and details in Contamination/Clearance Log.	Polythene
60	Nil RP controls are required once a system has been proved clear of contamination by 100 ml boil-down sample.	General
61	Gross wipe every item on all surface areas, take wipe and place on the beta contamination probe surface for 5 seconds.	General
62	To minimise the possibility of cross contamination the monitor must check him /herself.	General
63	Use of HEPA filtered Vacuum Cleaners. No changing of filters or emptying bags in RC. This can only be undertaken in APF.	General
64	No item which is to be cleared in the tunnel is to be monitored through polythene due to the significant attenuation of beta radiation.	General
65	If there is any doubt regarding the item (e.g. suspected internals), then the item must be sent to the APF.	General
66	Check swabs cleared i.a.w. BRSO-SD-102.	Swabs
67	NSI Swabs which are brought out of the RC by NSI are to be cleared by HP staff using direct probe. The swab will be in a plastic envelope.	Swabs
69	The tunnel monitor must place the enveloped swab on a flat surface and position the probe directly onto the surface area and leave the probe on the swab until the reading has stabilised. (This may take up to 5 or 6 seconds.)	Swabs
70	Both surfaces of the enveloped swab must be checked in this manner.	Swabs
71	If direct probe reading on each swab (contained within its own envelope) is not above background, the swabs are to be returned to NSI.	Swabs
72	Record NSI swab and results in Contamination/Clearance Log.	Swabs
73	If the results for the swab are found to be above background, the swab is to be treated as contaminated and returned by SSHP to ESHP Chemists via APF.	Swabs
75	No item which is to be cleared in the tunnel is to be monitored through polythene due to the significant attenuation of beta radiation.	Metlagging
76	If there is any doubt regarding the item (e.g. suspected internals), the item must be sent to the APF.	Metlagging
77	Only items highlighted (in 4.4.4 in Procedure Guidelines) may be transferred to barrier unbagged. Using gloves place item on appropriately demarcated polythene surface.	Metlagging
78	All surfaces are to be monitored using contamination probe as directed in General Monitoring Guidelines Paragraphs 4.3.	Metlagging
79	If the results of the direct probe are 5 cps or greater (above background), the item is considered to be contaminated. The item is to be bagged immediately and the laydown area checked for contamination. The bagged item will be transferred to APF.	Metlagging
80	Any contamination found is to be recorded in the RC Contamination/Clearance Log (Annex A) and the HP Supervisor contacted for further advice.	Metlagging
81	If the direct probe results are less than 5 cps (above background), the item is to be gross wiped.	Metlagging
82	Gross wipe every item on all surface areas. Take the wipe and place it on the beta contamination probe surface for 5 seconds.	Metlagging
83	To minimise the possibility of cross contamination the monitor must check him/herself.	Metlagging
84	If the results of the direct probe and gross wipe are less than 5 cps (above background), the item can be considered to be free of contamination and suitable for free release.	Metlagging
85	Record item and details in Contamination/Clearance Log (Annex A).	Metlagging
86	Gross wipe with tissue the complete surface area of each source container and place the tissue onto the probe and leave for 5 seconds.	Source Containers
87	If result is less than 5 cps above background, return the source container to NDE staff.	Source Containers
88	If result is greater than 5 cps above background, bag and set aside for transfer to APF.	Source Containers
89	Record details in Contamination/Clearance Log.	Source Containers
90	REDF staff to wear nitrile gloves during connection.	REDF
91	Contamination checks on staff undertaking connection. REDF staff who connect the PET to the high level discharge are to be checked for contamination on completion of task	REDF
92	Assume equipment is contaminated, double bagged and forwarded to the APF.	Waste
93	No item which is to be cleared in the tunnel is to be monitored through polythene due to the significant attenuation of beta radiation.	Waste
94	Waste is to be segregated into solid and liquid. Components are to be double bagged with absorbent material as required for liquids and an RMTL stating any hazards attached before forwarding to APF.	Waste
96	If there is any doubt regarding the item (e.g. suspected internals) then the item must be sent to the APF.	Waste
97	Use of HEPA filtered Vacuum Cleaners. No changing of filters or emptying bags in RC. This can only be undertaken in APF.	Waste
98	In order to minimise the generation of radioactive waste all packaging is to be removed from items prior to entering any Controlled Area.	Waste
99	A radiation survey is to be conducted upon the detector on removal from the housing and upon removal from the RC and additional shielding applied as necessary.	Detector Head
100	A radiation survey is to be conducted of the detector during removal from the housing and on removal from the RC and additional shielding applied as necessary.	Detector Head
102	During removal of the Detector it is to be passed from the housing into a polythene sleeve in order to reduce the risk of contamination. The end of the sleeve should then be taped shut.	Detector Head
103	Due to increased radioactivity at the lower end of the detector, Handling of the detector lower assembly tube is to be kept to a minimum. Nitrile gloves are to be worn whilst handling the Detector.	Detector Head
104	Shielding is to be available to shield the end of the detector.	Detector Head
105	A Contamination Survey is to be undertaken of the work area and detector tubing on completion of the task.	Detector Head

[June7]

That really doesn't offer any explanation of what the db is for and what you want to accomplish.

However, seems user need only read the first few words of each statement in order to decide which one to select.

[macaulayrg2003]

Hi June7,

In my form1 under the procedural control tab. I would like to select all the same type statemets in the one go, rather than individual ones as i have to do at the momments.

PS sorry for the mess of db it is my first attempt at this.

cheers

[June7]

Can't review your db until later.

What do you mean 'select all'? Aren't we talking about cascading comboboxes? You can have the memo field display in combobox, it just won't have the entire field content in the combobox column. That doesn't prevent selecting item.