Field with automatic symbol attached

[Topham]

Hello all,

Im at a stage of my database where a certain field need to have and automatic symbol as well as numerics. The symbol needed is an omega symbol (Ω).

For instance if i put 2.4 in the field it will show 2.4Ω automatically.

Regards,
Topham

 

[DCrake]

You will need to have the field as a text field then you will be ok. You need to conat the omega symbol to the string value of the entry. However if the omega is just for display purposes then why do you really want to display it?

 

[Topham]

As my client has requested it.

 

[Topham]

Im putting #,###.##Ω, its changing too #,###.##/Ω but when i input it in the field it only show the full number and not the decimel. so if i put 2.4 in it only shows 2. Ω

 

[DCrake]

Try

Me.Yourfieldname = Format("#,###.##",[Yourfieldname]) & "Ω"

in the after update event

 

[Topham]

where do i put this in VB or the macro?

 

[DCrake]

If you are displaying it on a form then use it one the AfterUpdate Event of the control.

If in a query

Alias:Format("#,###.##",[Yourfieldname]) & "Ω"

You could also create a custom input mask in your control on a form.