Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Microsoft Office > Access and Access VBA > Access
|
Access Discussion of Microsoft Access database design and programming. See also the forums for Access ASP and Access VBA.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old October 17th, 2003, 01:29 AM
Authorized User
 
Join Date: Sep 2003
Posts: 52
Thanks: 0
Thanked 0 Times in 0 Posts
Default Form and Report Style Problem

Hi all,

I have been looking on and off for these bits of functionality without success.

1) Is it possible to show the & as an actual character?
   for example any label or text box that might have the text "Name & Number" shows up as
   "Name _Number" using the escape char "Name \& Number" gives the predictable "Name \_Number"
   This happens everywhere in access. Can it be done?

2) Access says it can take in images of the type BMP or GIF. Try as I might I cannot get access to use a GIF.
   Every time I try it tells me via message box that I can only use BMP or GIF files!!
   A GIF file would be Ideal because it would save oodles of time remaking BMP files for other peoples bizarre
   color schemes.

3) Has any one ever gotten text and a picture on a button or menu? I currently am using BMP images with the
   appropriate text (problem 2) to get around this.

Thanks in advance for any light you might shed on any of these questions

-Roni


Roni Estein
Roni.Estein@e-drugscanada.com
https://www.e-drugsCanada.com
__________________
Roni Estein
Roni.Estein@e-drugscanada.com
https://www.e-drugsCanada.com
 
Old October 17th, 2003, 01:47 AM
Authorized User
 
Join Date: Sep 2003
Posts: 52
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Here is one more I forgot, sorry I gave up on these a while back.

4) When entering data into a textbox with a input mask if a user clicks the mouse to enter the text box
   then the cursor will be where the mouse click registers, not at the start point of the field.

   Is there any way to set it to the first character position.

   for example a text box where there is a phone number and you click into it you might end up
   on the fourth number. (###) #|##-#### <- the | symbolizes the cursor.

Thanks again
-Roni

Roni Estein
Roni.Estein@e-drugscanada.com
https://www.e-drugsCanada.com
 
Old October 17th, 2003, 02:11 AM
Friend of Wrox
 
Join Date: Jun 2003
Posts: 120
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Roni

1)You almost had this one! Typing in 'Name && Number' will display 'Name & Number'.

2) I do not have any problem using a gif file as the background to a form or report or in an image control. The help file for the picture property states explicitly that button controls only accepts bitmaps.

3) Can't be done, except in the way you're already doing it.


Brian Skelton
Braxis Computer Services Ltd.
 
Old October 17th, 2003, 07:43 AM
Friend of Wrox
 
Join Date: Jun 2003
Posts: 1,151
Thanks: 2
Thanked 14 Times in 14 Posts
Send a message via ICQ to SerranoG Send a message via AIM to SerranoG
Default

Brian answered 1 - 3. Here's 4. Try using something like this:
Code:
   Me.MyField.SelStart = 0
Read the help on the .SelStart property for more details.


Greg Serrano
Michigan Dept. of Environmental Quality, Air Quality Division
 
Old October 29th, 2003, 03:54 PM
Authorized User
 
Join Date: Sep 2003
Posts: 52
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Sorry for the late reply,
I have been swamped for the last few weeks. this stuff is great guys, it all worked like a charm.

Much appreciated.
-Roni

Roni Estein
Roni.Estein@e-drugscanada.com
https://www.e-drugsCanada.com





Similar Threads
Thread Thread Starter Forum Replies Last Post
Chapter 2 -- Style Sheet problem. Doug Happ BOOK: Beginning ASP.NET 2.0 BOOK VB ISBN: 978-0-7645-8850-1; C# ISBN: 978-0-470-04258-8 4 January 10th, 2008 01:14 PM
Problem loading report on a web form Imar BOOK: Professional Crystal Reports for VS.NET 1 January 15th, 2007 09:27 PM
Change page form style in VB Ron Howerton ASP.NET 1.0 and 1.1 Basics 7 October 26th, 2006 12:18 PM
cascading style sheet problem nikotromus ASP.NET 2.0 Professional 0 March 24th, 2006 07:49 PM
difference between style.visibility and style.disp Mimi Javascript How-To 6 September 17th, 2003 11:50 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.